Can’t connect to database – error message

For xampp localhost should be fine.
Do you have a user with a password in the database?
On my XAMPP install the user is “root” and it can access the db even without a pw, but for WP to work correctly I had to give the user a pw.

That’s fine – we re all bloggers 🙂
If “localhost” doesn’t work, you should ask your host what the DB host is.
Was the database created by you or by the host? WHat admin interface do you have: cPanel, Plesk…other?
At this place http://www.tamba2.org.uk/wordpress/ you can find several tutorials for different admin panels.

here I’ve created the database

mysql> CREATE DATABASE wordpress;
Query OK, 1 row affected (0.00 sec)

here I’ve enabled use of the database

mysql> USE wordpress
Database changed

here I created an account, and gave it access to the entire database wordpress

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
-> ON wordpress.*
-> TO ‘user’@’localhost’
-> IDENTIFIED BY ‘password’;
Query OK, 0 rows affected (0.00 sec)

here I test the login, from the localhost

bash$ mysql -u user -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6 to server version: 4.1.13

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

so… at this point mysqld is running, and the user has access to the database.

I also ran some simple tests to verify that everything had been created properly

for example:

mysqlshow -p
– to see the databases

mysql -e “SELECT Host, Db,User FROM db” mysql -p
– to see the database association with an account

all this data cooresponded appropriately with the above….

the only thing I can think of is….

“table_prefix”

does “wp_” have to be created manually?

does wordpress not create this?

If I install mysqladmin… do you think it will solve my problem? Or is there some other issue at hand here?

I’ve configured alot of databases manually… but never outside of a win32 environment. So I am new at configuring mysql on *nix, but with mysql it should be the same cross platform yes?

I am facing similar problem

I Cerated Data base user name as well as password

But when run the install.php script I get the follwing error

“Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the hnewar11_blog database.

Are you sure it exists?
On some systems the name of your database is prefixed with your username, so it would be like username_wordpress. Could that be the problem? “

Well any one can solve this problem

Mohammed

what about for me? 🙂

Ok, I get a similar error only have some of the time. I noticed when I tried a plugin demo, one of the contributors page gave me the same message.

I know the connection works at least some of the time (60%) or more, but at least ever hour I get the
Error establishing a database connection etc, etc.
Problem goes away in only a couple of minutes.

Anything in wordpress that may cause this? If not, I use CPanel, MySQL, and PHP MYADMIN to configure everything. I have not set up a generic localhost name, just left the “localhost” as it was.

Any thoughts? I am leaning toward the host since the sites I host on my servers don’t have the same trouble.

in my case it wasn’t any problem with wordpress

i just had the password wrong in the wordpress config

apparently the one i was logging into mysql was different

that day I would have sworn up and down they were the same but I came back another day and tried logging in with the password in the config file and it wouldn’t work; so i reset the password.

sometimes the best thing to do is, walk away and come back a few days later with a fresh mind.