Solved Wordpress Error establishing a database connection

Wordpress is top most used CMS in the world. You can create any type of website into Wordpress like Pharma, Packers and Movers, Hospital , School etc.

Some time you face the issue into wordpress website like “Error establishing a database connection”  when open the website. To solve this problem follow the below instruction .

1. First check the database username and password is correct. OR recreate the password and used the new one. check the wp_config.php file about what you entered into it.  If something wrong then correct it. Make sure you connection is successful when using the database login details using mysqli_connectoion fuction.
2. Next is rename the wp_content > plugins directory to plugins_del . So that refresh the website . Some time currupt plugins create the problem. If all ok then move the plusings one by one into plugins folder from plugins_del folder. You easily found the corrupt  plugin which create the problem.
3. open the wp_config.php file and write the below line at the bottom of page.
   
   define('WP_ALLOW_REPAIR', true);
   
   After that open the www.websitename.com/wp-admin/maint/repair.php file to repair the database table. Some time tables corrupted and show the error.
   
   You can repair the database from cpanel > phpMyAdmin > select database > select tables > select repair and optimize it .
4.  Last option is to take backup of database from cpanel.  create the new database and import the database copy here.