• Resolved cnick

    (@cnick)


    On my site motivational stories I’am getting this “Error establishing a database connection” error after every 5-6 min.I thing this may have to do with my up-gradation from shared to VPS servers.
    So my question is,did any one of you had similar problem after change of servers??How did you troubleshoot it.
    Does it had to do with high traffic or RAM usage??

    Note:All domain’s are giving same error.
    My host did some database synchronization which ofcourse didn’t worked.
    I didn’t had any problems with my old shared hosting.

    Thanks in advance.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator t-p

    (@t-p)

    In nutshell, you’re getting this error because WP is unable to establish a database connection. Reason why WP is unable to establish a database connection can vary. It could be that your database login credentials are wrong or have been changed. It could be that your database server is unresponsive. It could be that your database has been corrupted. Majority of the times this error happens because of some sort of server error. Also, there could be other factors as well.

    To troubleshooting this problem:
    – double check your wp-config.php file settings for the database name, database username and database password, and the host name (e.g., “localhost” Vs. something else). This is where most errors occur.
    – Then make sure wp-config.php is in right location.
    – Then check that you don’t need to change the database host from “localhost” to something else. You can get that info from your hosting provider.
    – Check you have actually created a database with the same database name as is in your wp-config.php file.
    – Last, but not least, if all that information is correct your database probably has a problem with it. Contact your hosting provider if the database server is offline (if the problem suddenly happened), or if they have any other problem at their end, or they made any changes to your account, or if there are any limitations/restrictions, or if the hosting package is set to Windows and not Linux, etc.
    – There are also many threads on this topic on these forums: http://ww.wp.xz.cn/search/Error+establishing+a+database+connection?forums=1

    Thread Starter cnick

    (@cnick)

    Thanks Tara for such a prompt reply.
    I’ll check all the above mentioned solution right now.

    Thanks again.

    Moderator t-p

    (@t-p)

    you are welcome 🙂

    Thread Starter cnick

    (@cnick)

    Turns out my RAM would get used up frequently which forced MySQL to restart.
    Optimizing database solved this problem.

    Moderator t-p

    (@t-p)

    Glad you got it sorted 🙂

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘frequently getting "Error establishing a database connection"’ is closed to new replies.