Apache@localhost access denied

[CassidyHunt]

I run this site and database fine on my workstation but when I put it on the server I get the following error:

Access denied for user: 'apache@localhost' (Using password: NO)

I try to grant permission to the user and I get access denied for that as well.

Is there anything else I can try?

Cassidy

 

[sleipnir214]

That looks like a MySQL error. It's saying that the database server is not accepting the credentials.

Remember, MySQL user credentials are not just a 2-tuple of username and password. MySQL user credentials are a 3-tuple of username, password and machine from which you try to connect to MySQL. It sounds to me like the change of machines has caused problems with the 3rd part of the 3-tuple.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[clivehenderson]

Not sure if this helps but I had a similar problem recently when I changed hosting companies.
This is a known issue with Sun ONE ASP and MySQL 4.1, but you can fix this yourself, simply login to your mysql DB and do 'set password=old_password("whatever the password is")'
This got rid of the problem for me.
Kind regards
Clive