Contents
Database connection error on WordPress? This common failure can make your site inaccessible and impact its search ranking. This article will guide you step by step to understand this error, identify its causes, resolve it effectively and prevent it from happening in the future.
In this article, we'll cover:
- What a database connection error is.
- The most common causes of this error.
- The impact on your website and its accessibility.
- Practical solutions to resolve it quickly.
- Tips to prevent this problem in the future.
Whether you're a beginner or an advanced user, this guide will give you all the information you need to restore your site quickly.
What is a database connection error?
When you try to access your WordPress site and you get a message like "Error establishing a database connection", it means that WordPress can't communicate with MySQL/MariaDB.
Unlike a 404 error, which indicates that a page can't be found, here the problem directly concerns the very structure of the site.
Why is the database connection error important to fix?
Impact on your website:
- Your site becomes completely inaccessible to visitors and search engines.
- Loss of traffic and potentially of revenue for e-commerce or professional sites.
Impact on SEO:
- If the error persists, Google may downgrade your site in the search results.
- A site that's down sends a negative signal to search engines.
Useful resources:
- Discover how Google interprets HTTP errors in the official Google Developers documentation.
The common causes of a database connection error
Incorrect connection credentials
- The
wp-config.phpfile contains incorrect information (database name, user, password, host).
Corrupted database
- An update that didn't finish properly or a server overload can damage the database.
Database server problem
- If your host's SQL server is down, your site will be inaccessible.
Corrupted .htaccess file
- A misconfiguration can prevent WordPress from accessing the database.
Too many simultaneous requests
- A heavy influx of visitors can cause a saturation of resources.
Misconfigured migration
- After a change of host, some settings may be entered incorrectly.
How do you fix the database connection error?
1. Check the connection information
- Open the
wp-config.phpfile and make sure these lines contain the correct information:
define('DB_NAME', 'nom_de_la_base');
define('DB_USER', 'nom_utilisateur');
define('DB_PASSWORD', 'mot_de_passe');
define('DB_HOST', 'localhost');
If you have shared hosting, DB_HOST may be different (for example: mysql.votre-hebergeur.com).
🔗 Official WordPress guide on wp-config.php
2. Repair the database
Add this line to wp-config.php:
define('WP_ALLOW_REPAIR', true);
Then go to https://votre-site.com/wp-admin/maint/repair.php and click "Repair Database".
🔗 Optimise and repair a MySQL database
🔗Use WP-CLI to manage the WordPress database
3. Restart the MySQL server
If you manage a VPS or dedicated server, try this command:
sudo service mysql restart
🔗 Handle errors and logs under Nginx
4. Disable the plugins and the active theme
If a plugin or theme is causing the error, access your site via FTP and rename the wp-content/plugins folder.
🔗 Disable all WordPress plugins manually
5. Contact your host
If none of the solutions above work, contact your host to check the status of the SQL server.
🔗 Comparison of WordPress hosting in 2024
🔗 Best recommended WordPress hosts
Preventing the database connection error in the future
1. Make regular backups
Use a plugin like UpdraftPlus to back up your site.
2. Optimise the database
Remove unnecessary tables with WP-Optimize.
3. Monitor server performance
Install ManageWP or use Google Search Console to detect errors.
4. Choose a reliable host
A good host offers stable performance and responsive support.
Conclusion
The database connection error is a recurring problem, but one that can often be resolved in a few steps. By following this guide, you'll be able to diagnose and fix this error quickly. To keep it from happening again, adopt good backup and monitoring practices for your WordPress site.
Need extra help? Check out our guides on the errors 404, 500, 502, 503 and 504 for a site that always works!
