MySQL problem

[Anon]

I have made a site in PHP&MySQL. It works on my local server. The access to the MySQL database is made through a password.
When I uploaded it to the web-host, I have encountered the following error:
Database error: cannot use database comauto
MySQL Error: 1044 (Access denied for user: 'comauto@localhost' to database 'comauto')
Session halted.
Thanks for any answer

[Anon]

Check with your hosting co as they are most likely running the db servers on a different server (and certainly not locahost). They will also have to give you a database name, user and password which you must put into your PHP.

It's a pain but I get around it by adding code the check the host name and use the appropriate database, user and password.

Check out to see if they have a FAQ with examples of how to use mySQL in their servers.

Cheers,

Cris

[[deleted]]

At the risk of sounding arrogant:
Shouldn't an 'access denied' massage make you check the permissions on the remote database?

[catalinus]

I have talked to the web hosting co and they explicitly told me to put "localhost" in the conn string. It seems that the person I spoke with is not competent enough to give the right answers.
I believe it is not a matter of access grant, as I have used the login name and the password provided by the web hosting co

[[deleted]]

Believe me, if MySQL says: "Access denied for user" it's an access rights issue.

A common problem is that sometimes your script will identify itself as 'user@hostname' and other times as 'user@localhost'.

The hosting people may have forgotten to add a host after the @,
or they added the wrong host. Or they simply didn't enter the correct username and password. You are sending the password along too aren't you?