database connections

Locked

Results 1 to 4 of 4

This thread is locked. New replies are disabled.

09 Jun 2006, 05:38

r885146

New Zenner

Join Date:: May 2006
Posts:: 16
Plugin Contributions:: 0

database connections

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?

09 Jun 2006, 05:45

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: database connections

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/showthread.php?t=13088&highlight=cpanel+create+database

09 Jun 2006, 15:36

fluffytigger

Zen Follower

Join Date:: Dec 2005
Posts:: 377
Plugin Contributions:: 0

Re: database connections

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.

09 Jun 2006, 17:02

vger

Past Contributor

Join Date:: Nov 2004
Posts:: 3,189
Plugin Contributions:: 0

Re: database connections

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