| View previous topic :: View next topic |
| Author |
Message |
Emerson1
Joined: 03 Mar 2013
Posts: 10
|
 Posted: Sun Mar 03, 2013 5:37 am Post subject: Error Establishing a Database Connection |
 |
|
If you are suddenly greeted with a white page with a single line of text telling you that there has been an error establishing a database connection, don’t panic.
If you are using WordPress to drive your site or blog, there are a couple of causes (and I’ve had problems with this over the weekend myself,) and a couple of likely solutions…
Cause #1:
Either one of the following are wrong
Your database username
Your database password
Your database name or
Your MySQL hostname
Solution #1:
Open your wp-config.php file and check these are correct and have not been changed. If you use cPanel to manage your site you can have a look at your databases and users there. Check with your web host for the required hostname. Some prefer localhost, others may use an IP address.
Cause #2:
The site has exceeded the maximum number of mysql connections allowed and thus it is down.
Solution #2:
My web host told me they have found this to be a very common issue over the last year or so with WordPress in which some plugin or possibly even a core component causes frequent corruption of the wp_options table (which is clearly odd since this table is very small with under 200 records most of the time).
Once the wp_options table is corrupted, the MySQL server generally will attempt an automatic repair which just runs and runs non stop due to something odd in the table which it doesn’t seem able to resolve or correctly identify/report.
When this is occurring, every future query to the wp_options table will queue up waiting for the table to be usable, thus leading to the max_user_connections being reached pretty quickly.
They went on to say they have only ever seen this behavior within WordPress and searching their forums or google will reveal tons of discussions of this type of issue, but unfortunately so far have not found any solution beyond disabling plugins/components in WordPress until finding the one that causes it.
This seems to be a very major issue which WordPress developers should be digging deeper into but so far I have seen no indication of investigation.
Finally, back in cPanel, it might also be worth using the Repair DB button, but if the database connections still get queued up the site may go offline again.
_________________
car loan for bad credit |
|
| Back to top |
|
 |
dustinedan2
Joined: 10 Mar 2013
Posts: 10
|
| Posted: Sun Mar 10, 2013 10:22 am Post subject: |
|
|
I know there are a lot of similar posts with this but I can't seem to find ... It sounds like you're running into a common pain point with local sandbox
_________________
cd duplication
dvd duplication |
|
| Back to top |
|
|
plumgallmann
Joined: 15 Mar 2013
Posts: 10
|
| Posted: Fri Mar 15, 2013 4:40 am Post subject: |
|
|
A fact that is by now well-established and not subject to any disputation ... world, is simply to have an access to a computer and an Internet connection. ... highly expensive 'trial and error,'... often re-inventing the wheel each time, ..... which is a site devoted to extensive compilation of a database of the most ...
----------
Plum Gallmann
online recruitment software
staffing software |
|
| Back to top |
|
|
aiidealjimai
Joined: 20 Jun 2013
Posts: 10
|
| Posted: Thu Jun 20, 2013 11:16 am Post subject: |
|
|
A fact that is by now well-established and not subject to any disputation ... world, is simply to have an access to a computer and an Internet connection. ... highly expensive 'trial and error,'... often re-inventing the wheel each time, ..... which is a site devoted to extensive compilation of a database of the most ...
_________________
show number plates
make your own number plate |
|
| Back to top |
|
|
Free Forum
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
