Tutorial : How to Prevent the Warning Error Establishing Database Connection on Wordpress

How to Prevent the Warning Error Establishing Database Connection on Wordpress#

The Warning Error Establishing Database Connection on Wordpress is a notification for a website when table "prefix name" not same with the wordppress database. This wordpress error can be definite with others means:

• When a person check outs your website and gets the message, it will release an error 500 HTTP standing code in your logs. This condition code will certainly appear when your website is experiencing "interior web server error".
  

This suggests there is something wrong on your web server and also the requested source is not sent by the server. If all works well, your website will certainly provide 200 HTTP standing codes, which means whatever is great.

• If PHP could not ask for information from the data source, you will get an "Mistake developing a data source link" message. The whole web page will be empty due to the fact that there is no information obtained to reveal on the internet browser screen. Not only disrupt the front end of your web site, it can also make you incapable to access your WordPress dashboard.

Do not worry and don't be panic about the problem, because I will share you the ways how to make the error can be fixed.
For example :
Table prefix name : wpq_ but the database php is wpa_ it is mean not same. The site can not be opened If this occurs to your wordpress site.

The others reason why this error for a wordpress site are :

Your WordPress internet site makes use of a different login info to get in touch with MySQL Data source.
The data source is corrupt. With the ever-changing areas of styles, plugins, and users frequently getting rid of and also installing them, often the database becomes corrupted. This can be brought on by tables that are missing out on or corrupted separately, or possibly some info was accidentally erased.
There is a damaged documents with WordPress setup or this issue could also happen because of hackers.

Here I will tell you the way how to solve this problem :

• Login to your wordpress cpanel
  
• Open the file manager
  
• Open the file for the error site
• Find the Wp-Config.php then open it.
  
• Find the table prefix name on wp-config.php
• Make sure the table prefix on the wp-config.php and phpmyadmin database is same. Like on the picture below:
  
  Well Done...!!!
  Your website can be acces again,.
  This Problem solving is only for the phpmyadmin database is not compatible to wp-config.php.
  Backup your wordpress data before do it. Thank you so much for @utopian.io that was given me a chance to share this tutorial, this is benefit for the wordpress beginner
  Thank You.

---

Posted on Utopian.io - Rewarding Open Source Contributors

---