MySQL weird "access denied" problem

can't connect via PHP

[lZakl]

When I set up a new user, I can't connect to the MySQL databse via PHP. It gives me:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'example'@'localhost' (using password: YES) in connect-test.php on line 32

The problem is that using the same username and password in 2 different MySQL management tools it connects just fine. It is only through PHP that the authorization fails. What could cause this?

I have even tried changing the password to "OLD_PASSWORD" and even tried it non-encrypted "in the clear" for testing purposes. I really am stumped with this one!

-- Zak

[volatilegx]

Make sure localhost is in the list of allowable domains from which to accept connections.

[lZakl]

I found that if I create a new user with localhost as the domain instead of %, it works. So I am guessing that localhost isn't included in %? If that's the case, how can I get it to be, or do I have to create duplicate users: One with % as the domain and one with localhost as the domain?

-- Zak