Error Establishing Database Connection

Hi
I have got message “Error establishing a database connection” too.
I have read a lot of docs… and found solution:
My hoster put database server at another PC with different IP.
This means that nor localhost, nor direct IP of my server as db_host not worked.

Nice!

Hello from Canary Islands (Spain),

First of all, I am sorry for my english, it is very bad.

I am trying to install WPMU, but I always have the same error “Error establishing database connection”.
I am sure that DBName, DBUser and DBPassword are correct, I can access database with a front-end (SQLYog).
I have my own webserver, and I want to install WPMU because I want to give multiblog-service to my users.
I have read a lot of documentation about installation of WPMU and all of them said to delete wp-config.php and run the index-install.php, but always is the same, I don’t know what to do, please help.

Thanks,
Elia Rivero

I too have spent a few days trying to configure this thing.

Here are some problems and their resolve:

1) First the zip program unloaded all of the files into one folder, so path names became invalid:
Resolve: I used WinRar to unzip – got that tip in these forums – thanks!

2) Files were missing after the FTP upload. Probably due to a time out or break in connection.
Resolve: Checked files and uploaded missing files.

3) The database I created had a different name to the directory I had created. Now this may sound really basic, but I was getting exactly the same error messages that were mentioned here. I re-checked installation procedure and nowhere does it say that the database name should be the same as the directory name – eg if WordPress was uploaded into your directory as /blog, then the database should be called ‘blog’ – well I am assuming this, because when I created a new database called ‘blog’ KAZAAM! I got a welcome message!
Resolve: make sure database and directory name are the same – I think.

Resolve: make sure database and directory name are the same – I think.

False.
It doesn’t matter what the name of the database is. I have the strangest DB names you can think of ?? – and they always work.
Probably, the second time you didn’t make a mistake that you certainly did during the first trial.

I Am Getting Following 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 sql2.hosting.1-2.in. 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’ve had the same problem. My web hosting techies wrote a little script similiar to the one above and it connects to the database. They even changed the password of the user just in case I was doing something wrong.

I thought it might be something to do with the same problem mentioned by jamesdiss but the script doesn’t through any error messages.

I’m really stumped now. And very frustrated.

Cracked it !

In the end I had to copy my backed up WordPress files to the server but I left the database blank.

I then ran the install program (install.php) which populated the database with tables.

Using phpMyAdmin I deleted a table one at a time from the database and imported the corresponding table from a database backup. I did this until I imported the table that was causing the error message. This was the wp_options table. I’n not sure which part of the table was causing a problem.

I then deleted all the tables, repeated the install program and re-imported all the tables except wp_options.

The drawback to this was I had to re-configure my sidebar modules but with the site being down nearly three weeks I was just grateful to have something to work with.

I had exactly the same problem on Mac OS X Leopard. If I used localhost as the address of the DB, it didn’t work, while if I used 127.0.0.1 it did work.

Hope that helps.