I am having the same problem, but I am using the wordpress walkthrough install so the error is:
"We were able to connect to the database server (which means your username and password is okay) but not able to select the [databasename] database."

If I manually put the info into a wp-config.php file, I get your "Error establishing a database connection" error.

I've double checked for typos, I've tried `localhost`, `127.0.0.1`, `linode_IP` with no luck (also changing the host in mysql permissions).

I can access the database using the command line `mysql -u my_user -h 127.0.0.1 -p` and `use database my_database;`.

Any suggestions?

My databases are both accessible and permissions are set as well but I can not seem to get a connection between the two. Would love it if someone could shed some more light upon this one.

EDIT :: Just checked and make sure the 'wordpress' DB has information in it and it seems to all be there, Just not sure how it got disconnected from my site in the first place. The answer must be so trivial.

EDIT EDIT :: Still plugging away at this for the 3rd day straight .. all of my sites are getting this SAME error. The answer has to be the same throughout all the sites, seems like theres a problem with sql talking to the wordpress config files. Been scouring the web but nothing it turning up. Will post back if I find any other ideas.

-Tantrik

I am calling this a loss, going to rebuild the server but would like to keep my entire website. Other than downloading all the wordpress files, is there anything else I need to take to be able to bring this website over to my new build? Such as the sql database? If so, how is it that I obtain this database.

-Tantrik

Tantrick,
If your other domain resolves and access the database then it is *not* the server and rebuilding will only be for practice.

You may want to scuttle this wordpress install and try again.


MSJ