Error establishing a database connection

please tell us clearly … actualy what happened and what is the error shown by wordpress install. Post the error here.

I have a similar issue:
– I have downloaded the latest wp-release
– I’ve installed mysql (5.1.31) locally on my macbook pro (os x 10.5.6) and have set up a database with a user that has full rights on the db.
– I’ve (renamed and) edited the wp-config.php file.
– I’ve enabled web sharing
– As DB_HOST I have tried both ‘localhost’ and the hostname of the computer’s website from the web sharing dialog in system preferences.

I’ve previously set up wordpress for my externally hosted website, which was a breeze btw. I’m starting to suspect it might have something to do with how the db is set up on my local machine, but I haven’t being able to solve it by googling for it.
Any and all advice will be appreciated.

And yeah, I get the same ‘error establishing a db connection’ message as hd198871.

Thanks,

@grandsorcier

Did you install MySQL onto your harddrive directly or did you install Xampp first, which btw comes with MySQL?
I have Xampp (complete with MySQL) installed on another computer which I use for developing the sites and it was a breeze.

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 DB_HOST. 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?

why i get creay!!!!!!
have you been suffer it before???

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 DB_HOST. 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?

Error message is self-explanatory. Either the database server is down or you’ve entered the wrong details.

why i get creay!!!!!!
have you been suffer it before???

?

@lenk
Well thanks for contributing nothing. Your smug comment sure helped alot. Idiot.

@eloquentbohemian
I’ll have a look-see at xampp, thanks for the advice.

@grandsorcier & [email protected]

The Xampp is different if you install on Mac or MS Windows.
Read the WP Codex here

@[email protected]

Smug? Hardly. I quoted the first part of the question because the error message is self-explanantory. You’d be amazed how many people post that message in this forum believing they have entered the correct details when in fact they didn’t. Point I was trying to make is re-check the details to be absolutely certain so that that possibility can be removed before moving on to something else.

I quoted the second part of the question and replied with a “?” because I didn’t understand what he was trying to say.

If hd198871 thinks my response was smug then I apologize for it wasn’t meant to be. As for you I could care less how you take my responses. Have a nice day.

See, it wasn’t that difficult to be polite now was it?

It doesn’t change the fact that I perceived your reply as being smug. Just to quote someone’s message and basically ask him/her if (s)he’s too stupid to read isn’t helpful. If you were really trying to help you could have made more of an effort. Myself being “technically challenged”, I kind of depend on helpful people in forums like this when my google imagination runs out, and there are usually lots of good people that understand how difficult it can be at times and just go that extra distance trying to be helpful.

“…that possibility can be removed before moving on to something else.”. Now a suggestion on what that “something else” could be, THAT would have been very helpful. I don’t know about hd198871, but I’m still stuck exactly where I was yesterday. And by the looks of it, not moving either.

Well, I’m having the same connection issue listed above of ‘Error establishing a database connection’ and to assist in trouble shooting I have created a small PHP script on the same server as WordPress with the same connection information. The test script works yet WP does not.

Any other thoughts?

CK

Ok, it would appear that the randomly generated password by phpMyAdmin is to long for the config creation tool in WP to handle because when I change the password from ‘AYZXLe3ZvfKAdeum’ to ‘test’ the config file is then generated. If I then change the password in the config file back to ‘AYZXLe3ZvfKAdeum’ (and back to on the DB server) the install portion is ok with it. I might suggest someone (not me – no time) inspect the config file creation code for a password limit bug.

CK

@[email protected]

You ought not perceive anything in an arena such as this. Text is a poor medium to convey emotion and as such you have no idea of my intentions or motivations. Assumptions are unwise. Anyway, enough of this nonsense and back to the problem at hand.

The only things I can think of (and I’m being redundant I know) is make absolutely sure database name and database user are correct. Some hosts preface the database name with your username such as username_databasename. Make sure said user has been added to the database with necessary privileges. On most hosts (but not all) the database host is localhost. Double check that. Beyond that I’m out of ideas. Hopefully someone else with a fresh set of eyes will pop in.

Try opening the PhpMyAdmin and check your database password and username. If possible try posting your config.php file here (but without username and password, i hopt u understand what is security?)

Awaiting…

@hd198871
I finally managed to solve the issue by using the localhost IP-address “127.0.0.1” instead of ‘localhost’ for ‘DB_HOST’ in wp-config.php. Weird considering that this IP-address is mapped to localhost anyway…?

Hope this helps.