Support Center
database.
Start here and get the help you need.
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…
Fixing the “Error Establishing Database Connection” Error
Learn what causes database connection errors such as “Error establishing database connection” on your WordPress website, and how to resolve these errors if you encounter them.
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.
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.
Reset a WordPress Admin Password
Learn how to reset your password the traditional way through email, and through the database if your wp-admin isn’t accessible.
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.
Migrate Posts/Pages Between WordPress Websites
Learn how to migrate and merge WordPress posts and pages from one site to another, without overwriting existing posts and pages.
