Error Establishing a Database Connection in WordPress
July 20, 2014
Eek! received an email that Google couldn’t get to my robot.txt file, checked the WordPress part of the site, to find the error: Error Establishing a Database Connection.
I was preparing to hunker down for the afternoon to find a solution, but the first result from DuckDuckGo pretty much solved it for me 🙂
From Beginner’s guide to WordPress: How to Fix the Error Establishing a Database Connection in WordPress
The database may need to be repaired”, then you need to repair your database.
You can do this by adding the following line in 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
Everything checked out OK, except for the one problem table: wp_options: Table is marked as crashed and last repair failed
My suspicions were confirmed, plugin problems! 😉
I’ve been through the exercise of deactivating / activating plugins in the past, it’s timely and tiresome. This time I found a much quicker simpler solution, from the WordPress Codex
Reset your plugins folder via FTP or the file manager provided in your host’s control panel.
- Via FTP or your host’s file manager, navigate to the wp-contents folder (directory
- Via FTP or your host’s file manager, rename the folder “plugins” to “plugins.hold
- Login to your WordPress administration menus (/wp-admin)
- Via FTP or your host’s file manager, rename “plugins.hold” back to “plugins”
A task I thought that would take hours to fix, resolved in less than 5 mins