How To Fix “Error Establishing A Database Connection” in WordPress

• Updated on: 2021-07-16
• Read original article here

It’s unsettling when you go to your website expecting to see your amazing design only to be faced with a blank screen and a message that says “error establishing database connection.” This error occurs when WordPress can’t connect to that database. Several things can cause this connection error. In this article, we’ll explore what causes the error establishing database connection message and see how to fix it.

A database is a table that stores content such as your posts, pages, widgets, colors, titles, etc. This data can be accessed, organized, and retrieved by WordPress to display to your visitors.

It works great. Until it doesn’t.

If the database can’t be accessed, you’ll see a message that says “error establishing database connection” and a blank screen. It’s blank because it has no data to display anything else.

First, don’t panic. This is a common error, and it doesn’t mean that your content is lost. It is fixable.

Several things can cause this error. The most common include:

Let’s look at the steps to troubleshoot and fix the error establishing database connection error. Once you’ve found the problem, there no need to do the rest of the steps.

This is the most common cause of the error establishing database connection error. Incorrect database credentials don’t change on their own, but this could be the problem if someone has been making changes to the files, hosting, etc.

WordPress stores the data in a database management system called MySQL. This database is stored on a server. To access the database on this server, WordPress needs some information:

These are the database credentials. All this information is stored in the wp-config.php file. If any of this information in the file is incorrect, WordPress cannot establish a connection and you’re given the connection error.

To check your WordPress database credentials, you’ll need access to your server’s files. In your host’s cPanel, select File Manager and then select the folder for your website.

Your files might look different from mine. I have one main site and a lot of test sites under that one. Because of this, I have a public_html folder that has the files for my main site and individual folders for all the other sites on the server. Open the folder for the site you want to check.

Look for the file named wp-config.php and right-click to open the options. Download a backup before making changes, and then select Edit.

Scroll down to find a section labeled MySQL settings. Look for the information with the database name, username, database password, and hostname. Next, you’ll need to verify that this information is correct.

Next, look at your current databases to confirm your database name and username.

Then, scroll to the section with current users. Here, you can see the usernames and change the password.

If the database name, username, and password doesn’t match, make the proper changes and try reloading the website.

Try to open your WordPress dashboard by adding /wp-admin to the end of your URL like this:

If you see the error “establishing database connection” message, move on to the next step. If you see a different message, follow the information it provides. This could lead to the solution.

If you can enter the dashboard, then try to deactivate plugins, themes, or code until the problem is solved.

Try to log into your website as an admin and see a message that says something like “One or more database tables are unavailable. The database may need to be repaired”.

In this case, you can repair the database by adding a line of code to your wp_config.php file.

Open the file and scroll to the section that says ‘That’s all, stop editing! Happy blogging’. Just above this line, add this code:

Next, go to the repair page at your website: examplewebsite.com/wp-admin/maint/repair.php

This gives you two options:

Both can take a while to complete. Anyone can access this page. Once you’ve completed the repair, remove the code from your config file.

We don’t expect our servers to go down, but it’s difficult for any server to have 100% uptime. This is more likely to happen if you’re on a single server. If you’re on a cloud-based plan, then your site will simply pull from another server if one goes down.

If you’re on shared hosting, your server could go down due to heavy traffic. When this happens, your site can give this error if the server is slow enough.

First, if you have multiple websites on the server, make sure they’re working.

Second, if you have a VPS, dedicated, or local server, go to your hosting account and look for a notification about your server’s current status. If your server is not running, you might need to reboot it.

Even if your server is running, rebooting it might help. In your hosting account, look for an icon about restarting your server and click it. This will only be available for VPS, local, and dedicated servers. Shared hosting won’t have this option.

WordPress files may be corrupt due to an out-of-date plugin or theme, or even the WordPress core. It could have failed during an update or when connecting the website to an external service.

To solve this, you can remove the files via FTP or by accessing the files in the host’s admin panel. The file structure is the same.

To access the files in cPanel, go to the Files section and select File Manager.

If your website is the main site on your server, look for public_html and click it. If it’s another site on your server, look for the folder with that site’s name and click it.

Look for a folder called Content and click it.

Now, look for the folders for your themes and plugins. Rename the folder you suspect has the culprit. If you’re not sure, think about what was updating or needed updating. Consider the quality of your themes and plugins. I find that plugins are usually the problem if something is corrupting my files.

If this solves the problem, then rename to folder back to its original name and enter the folder. Next, rename one of the plugins or themes and test the site until the problem goes away. If it does go away, then delete the plugin or theme that’s causing the error establishing database connection error.

If you’ve renamed the plugins and themes folder and the problem persists, plugins and themes are not the problems.

Another possible problem could be the site URL for the database. This one is less likely to be the problem, but if nothing else works then it’s worth trying. In the host’s cPanel, go to Databases and select phpMyAdmin.

This opens a query editor allowing you to run SQL on your database. First, choose your database from the list. Next, select SQL. Then, add this line of SQL with your URL:

Finally, click Go. This will update your URL for the database. Once it’s complete, load your website again to see if the problem is solved.

If your WordPress files are corrupt, download a new copy of WordPress and unzip it.

Delete the wp-content folder and the file called wp-config-sample.php.

Finally, upload the files to the WordPress root folder. This will overwrite all files except for the two you deleted in the step above. Now, try your site to see if it works.

If nothing else works, it’s time to contact your host for help. They can provide you with further steps to take. Many hosts will step you through troubleshooting the problem. It’s also possible that they can fix it for you.

That’s our look at troubleshooting and fixing the error establishing database connection message on your WordPress website. These steps are not difficult but it can take time to trace down the problem.

Always use quality themes, plugins, and hosting. Also, be sure to have a backup available just in case there are no other solutions. Before deleting important files, contact your host for help.

We want to hear from you. Have you had the error establishing database connection error? What did you do to fix it? Let us know in the comments.