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 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 how to connect to your website’s database remotely if your workflow requires you to access your database without going through phpMyAdmin.
Learn about WP Engine’s optional Object Caching layer, what it does, and how it’s beneficial to your site’s performance.
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.