Forums

WordPress can't connect to my MySQL Server (5 posts)

  1. johnnyICON
    Member
    Posted 4 years ago #

    Hi, just downloaded WordPress and installed MySQL on a remote server. I am able to connect to my MySQL server remotely using MySQL Administrator and through websites like http://flashmyadmin.freemysql.net/flashmyadmin.htm. But for some reason, WordPress cannot connect to it. I get

    Error establishing a database connection

    This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at XXXXXXXX:3306. This could mean your host's database server is down.

    * Are you sure you have the correct username and password?
    * Are you sure that you have typed the correct hostname?
    * Are you sure that the database server is running?

    If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.

    I don't know what the problem is. I've forwarded TCP requests on port 3306 to the server. I've set up a new user for wordpress, along with a separate MySQL Database, and modified the wp-config.php accordingly. I've done all this and still nothing. What gives?


  2. Moderator
    Posted 4 years ago #

    In 99.99% of cases this is related to incorrect information in the wp-config file.

    4 pieces of info you must check.

    DB name

    DB username

    password

    host

    And I know you will read this and think, 'yeah right - thanks that helps' - thinking you have checked it already, but as I say, in nearly all instances - it is a simple matter of one of the above pieces of information being wrong that causes the problem.

  3. johnnyICON
    Member
    Posted 4 years ago #

    Well, I'll try again. Thanks for the help.

  4. moshu
    Member
    Posted 4 years ago #

    Did you add the user to the database with all the privileges?

  5. wj830727
    Member
    Posted 3 years ago #

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.