database.

Learn how to deactivate plugins and change the theme of your site when the WP Admin dashboard of your WordPress website cannot be accessed.

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…

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.

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.

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.

Learn the best practices for optimizing a WordPress database. Cleaning up your database removes unwanted data and speeds up your WordPress website.

We’ll explain what Serialized Data is, what conflicts this type of data may present, and the most common solutions to serialized data issues.

Learn about WP Engine’s optional Object Caching layer, what it does, and how it’s beneficial to your site’s performance.

Learn how to reset your password the traditional way through email, and through the database if your wp-admin isn’t accessible.

Learn steps to import your database using phpMyAdmin in your WP Engine User Portal, as part of your manual migration process.

Follow this easy how-to guide in order to export & download your WordPress database from your current hosting provider, through phpMyAdmin.

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.