Grr… I solve it!

Sometimes i wonder what tech support are doing…
Or maybe i’m just too critical.

Or i’m just IT-savvy enough for my host / friend, to let me solve it by myself.
*Grrr…*

Anyway, thanks to FoxTwo.

For informing me on my site’s WordPress MySQL database error.

“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 localhost. 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.”

*****

What i did to fix it:
1) find file: wp-config.php
2) ensure mysql database name, user name and password is correct (eg. db_name, db_user and db_password)
3) change db_host to your direct mysql address (eg. mysql.domain.com)
4) leave the rest, upload and overwrite your old wp-config.php file

And if it still doesn’t work as planned, update your WordPress to the latest version and overwrite your wp-config.php file again.

If all the above fails, it could be due to server problem.
Please ask your web host to check their database server.

Hmm…
I wondered if it was due to the US host’s database… *ponders*

Grr… yes it was due to US host, changing its database server to a dedicated one, without sending out an email and informing its users. They assumed we would BROWSE / READ their forum dilligently for updates…

To them:
STOP ASSUMING AND DO YOUR JOB.
WE ARE PAYING TO HOST OUR SITES AND YOU AREN’T DOING YOUR PART OF THE DEAL!

12 thoughts on “Grr… I solve it!

  1. LOL well you shoulda just gotten an offsite SQL database πŸ˜€

    Glad you finally fixed it… it’s been down the whole day.

  2. @ soul:
    thanks πŸ™‚

    @ FoxTwo:
    nah, it’s just the US host changing it to dedicated server and not informing the users about it. my friend scolded the US host le πŸ™‚

    @ malique:
    if i rmbr correctly, US host is Jodohost.

  3. @ ecl:
    no lah, actually it’s quite easy to set up own domain. for you, maybe you just need to buy a .com url address and link it to your blogspot blog πŸ™‚

    it’s slightly more ma-fan (troublesome) to use wordpress, ‘cos it requires database support and i hate it when US host don’t notify us, on changes and updates.

  4. So US host also gave you problem. As you know I’ve had my problems with my Sin host too. Looks like we’re stuck between a rock and a hard place πŸ™

    Since FoxTwo has been so vigilant in catching your site’s downtime, maybe we should all host with him to enjoy his truly 100% 24/7 real-time monitoring service πŸ˜€

  5. Chocs are bad for hamsters! NooOOoo I want fresh, green, leafy vegetables, or fruits and nuts.

    MissLoi – you should get YOUR webmaster to read my blog entry about disaster recovery and he’ll probably figure out what to do haa!

Comments are closed.