Databases.
Add WordPress Admin User with phpMyAdmin
You can create a new WordPress admin user directly from the database. Use this method if you need to add a new user to the site without having to sign in to the WordPress dashboard. Add WordPress Admin Open the User Portal Select the Environment name to edit Click phpMyAdmin at the top Select your…
About ORDER BY RAND()
Learn about the option to enable ORDER_BY_RAND() in MySQL queries, why we disable it by default, and important performance information to know when using it.
SQL Queries in phpMyAdmin
Learn how to access phpMyAdmin to run a SQL query in your WordPress database and how to run a query when your WordPress site has a custom database prefix.
WordPress Database Optimization
Learn the best practices for optimizing a WordPress database. Cleaning up your database removes unwanted data and speeds up your WordPress website.
Serialized Data in WordPress
We’ll explain what Serialized Data is, what conflicts this type of data may present, and the most common solutions to serialized data issues.
Setting Up Remote Database Access
Learn how to connect to your website’s database remotely if your workflow requires you to access your database without going through phpMyAdmin.
Object Cache in WordPress
Learn about WP Engine’s optional Object Caching layer, what it does, and how it’s beneficial to your site’s performance.
Import a WordPress Database
Learn steps to import your database using phpMyAdmin in your WP Engine User Portal, as part of your manual migration process.
Export a WordPress Database from Another Host
Follow this easy how-to guide in order to export & download your WordPress database from your current hosting provider, through phpMyAdmin.
Change WordPress Database Table Prefix
If you use a non-standard prefix for your database tables, this article will assist you in changing your WordPress database table prefix set in the wp-config.php file.
