WordPress website uses MySQL database to store and output data in your frontend. Having this error “WordPress Error Establishing A Database Connection” means you are not able to connect to the database or the database is not configured well.
The “Error Establishing A Database Connection” error occurs when your database information (Database Name, Database Username, Database Password, and Database Server) is incorrect. It is possible also that the database got corrupted or the database hosting server is down.
In this guide, we will teach you how to fix this error.
Check Your Database Credentials
The first thing to check is looking at the database configuration that can be found in wp-config.php. This is where you put the correct database information mentioned above.
// ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define( 'DB_NAME', 'database name here' ); /** MySQL database username */ define( 'DB_USER', 'database username here' ); /** MySQL database password */ define( 'DB_PASSWORD', 'database password here' ); /** MySQL hostname */ define( 'DB_HOST', 'database server here' );
Make sure that the credentials are correct by checking your website hosting dashboard.
Simply find the MySQL Databases settings, and you can see all the information there.
Once you checked and updated your database information, try to reload the website if the error has been corrected.
Try to Repair your WordPress Database
If the error is still there or WordPress is asking you to repair the database, here’s how to fix it.
Just copy the code below to your wp-config.php file. Make sure to add it below this line “/* Add any custom values between this line and the “stop editing” line. */”.
define('WP_ALLOW_REPAIR', true);
Once it is done saving, try to visit your website with this URL format “https://yourwebsite.com/wp-admin/maint/repair.php”.
You just have to choose either you only want to Repair Database or Repair and Optimize Database.
After the repair, make sure to remove that line of code you added because it will still work even if there is no user session logged in to your website.
Contact Hosting Provider
If your problem still did not fix, try to contact your hosting provider if there is any problem with their servers or just let them reboot your web server.
Wrapping Up
I hope that this article helped you in fixing your WordPress database and make it run smoother and faster.