database connections

**r885146** · 9 Jun 2006, 06:38 AM

I have created the database called bookstore and have a username and password. but I still get the error:

Connection to Database failed
Access denied for user 'bmike'@'localhost' or

Database does not exist
Access denied for user ''@'localhost' to database 'books'

What could be wrong?

**DrByte** · 9 Jun 2006, 06:45 AM

This archived thread won't let you reply to it, but there are some general instructions in it that may be helpful in helping you grant the "user" permissions to use the "database" you created.

http://www.zen-cart.com/forum/showth...reate+database

**FluffyTigger** · 9 Jun 2006, 04:36 PM

Can you connect to it some other way like via phpMyAdmin or through shell with that account?

If no, try setting the user's host to localhost.

**Vger** · 9 Jun 2006, 06:02 PM

Go to your web hosting control panel and click to Manage Databases, and then see what the actual name of the database is.

It may be that you created a database called books but that the full name is yourdomain_com_-_books

It may also be the case that your database address is not localhost but 127.0.0.1 (the ip address for localhost). If your host uses Red Hat Enterprise Linux as the operating system this will definitely be the case.

Vger