How to fix error connection in database in wordpress
What is causing the error in creating a database connection in WordPress?
An error connecting to a database can be caused by incorrect database information in your WordPress settings, a corrupted database, or an unresponsive database server.
WordPress needs the following information to connect to the database:
Database name
Database username
Database password
Database server
This information is stored in a WordPress configuration file called wp-config.php.
Step 1. Check your WordPress database credentials
The most common cause of a database connection error in WordPress is incorrect database credentials.
You will look for the following lines in the wp-config.php file.
You need to make sure that the information for the database name, username, password and database host is correct.
Step 2. Repair the WordPress database
If you get another error in wp-admin, for example, something like “One or more database tables are unavailable. You may need to repair your database”, then you need to repair your database.
You can do this by adding the following line to your wp-config.php file.
Once you have done that, you can see the settings by visiting this page:
http://www.yoursite.com/wp-admin/maint/repair.php
Click Repair Database You can easily log in.
OR
Go to the open phpmyadmin database
לחץ על בדוק הכל ובחר טבלת תיקון
After clicking on a repair table you will see your database repaired.
You can now enter your site.
Step 3. Check if your database server is down
If everything seems to be fine, WordPress can not connect to the database yet, your database server (MySQL server) may be down.
This can happen due to heavy server traffic. Basically, your host server just can not handle the load.
