Error establishing a database connection – where to fix?

  • Resolved dantesdame

    (@dantesdame)


    6 years, 12 months ago

    I’ve read through some of the fixes and they were helpful – up to a point. I am a weak WP user – I like plug n play stuff.

    That being said, I recently updated my MySQL to 5.5 (as requested by WordPress). The site is hosted on Godaddy, and I did this through their site. I had to create a new database name and password. However, now when I load my site (including the wp-admin page) I get the “Error establishing a database connection” message.

    The message is, in part:
    This either means that the username and password information in your wp-c
    onfig.php file is incorrect or we can’t contact the database server at
    “databasename”.db.3142720.hostedresource.com. 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?

    I can see the old database server name listed here, and know that I need to update it, but how? Where? Is this something that I need to do via Godaddy? Or is there some trick into getting into my WP site to make changes?

    The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    6 years, 12 months ago

    Did you update wp-config.php for the new user, database, password, and host name?

    Stef

    (@serafinnyc)

    6 years, 12 months ago

    You most likely have your config file incorrectly configured.

    Make sure you have define( 'DB_HOST', 'localhost' ); for the hostname and not anything else.

    The other info don’t tell me and don’t post here at all. Just make sure you have the correct username and password. This will be in your cPanel if you don’t recall. Make sure the username you are using is applied to this database. If you need you can always change the password too if you need.

    Davood Denavi

    (@binarywc)

    6 years, 12 months ago

    Definitely double check your wp-config.php file to be sure you have all the db credentials set correctly as Steve suggested, but check with your host to be sure about the db host part because some hosts use a different server to host their databases and the host wont be localhost if they do.

    Hope this helps. Once you find a solution please tag the thread resolved.

    Stef

    (@serafinnyc)

    6 years, 12 months ago

    Who’s Steve @binarywc

    Davood Denavi

    (@binarywc)

    6 years, 12 months ago

    @serafinnyc Look at the previous posts in the thread. I intentionally did not tag him because there is no need to tag him since the comment was not directed at him.

    Stef

    (@serafinnyc)

    6 years, 12 months ago

    LOL he snuck in. Look at the time stamp. I was like who’s this Steve guy

    Davood Denavi

    (@binarywc)

    6 years, 12 months ago

    @serafinnyc It’s all good. I had not realized that about the time stamps myself until you pointed it out. Have a nice day.

    Stef

    (@serafinnyc)

    6 years, 12 months ago

    It was only me until you commented. I don’t get a notice when a mod comments.

    You too man. 🍺

    Thread Starter dantesdame

    (@dantesdame)

    6 years, 12 months ago

    Hi all
    I appreciate the immediate support and suggestions!
    I believe that the config update was what was needed, and I didn’t know how to do it. I ended up calling my hosting company and they fixed the connection problem. I asked them for more specifics on the error, and he just repeated that it was a connection problem, so I left it at that.

    Stef

    (@serafinnyc)

    6 years, 12 months ago

    @dantesdame glad you were able to get it squared away. 🙌🏻🤙🏻

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

The topic ‘Error establishing a database connection – where to fix?’ is closed to new replies.