Error Establishing a Database Connection

[Neha]

Hello,

I am facing error of database connection on my site.



Can anyone please help how to remove this error.

[Lalit]

Hello,

Possibly there could be two reasons, the database username and password are incorrect in the wp-config.php file or the database is corrupted.

Please make sure that you have correct database credentials under wp-config.php

Let me know the control panel you are using so we can help you with the exact steps?

[Neha]

Hello,

The control Panel which I am using is cpanel.

[Neha]

Thanks I have resolved it.

[Mandeep]

If it's a WordPress website then you must follow the steps provided below:

Step 1. check the wp-config.php file and look for the similar code shown below.

/** The name of the database for WordPress */
define('DB_NAME', 'vidavibe_xxxx');

/** MySQL database username */
define('DB_USER', 'vidavibe_xxxx');

 /** MySQL database password */
define('DB_PASSWORD', 'X834547Y&$pD9');

/** MySQL hostname */
define('DB_HOST', 'localhost');

Note** : For MySQL Host, assuming you are using local MySQL server.

Step 2. Make a note of the database name, database user, and password in a notepad.

Now that you have all the necessary details, you can login to cPanel account of this user.

Step 3: Go to cPanel >> MySQL® Databases >> Under Current Databases >> look for the database name that we have found from wp-config.php file. In our case, it is "vidavibe_xxxx"




Step 4: Check if the database name is correct and user in front of it under Privileged_users is correct too.




Step 5: Thereafter, move to 'Current Users' >> In front of the username, you will find an option to 'change password'





Step 6: Upon clicking change password, you will be asked for new password. >> Enter the password same as that we found in the wp-config.php file i.e X834547Y&$pD9 >> click on change password.


This should fix database connection error on your WordPress website !!!


The above steps are for WordPress website. If you are using any other application then you will need to check for the database connection string. The rest steps from cPanel remain the same as discussed above.