Trying to enable users, keep getting "Access denied"

[bunner_bob]

Wah!

I created the following user:
mysql> grant all on * to testuser identified by 'testuser';
Query OK, 0 rows affected

I submit this query via PHP:
$db = msql_connect("localhost", "testuser", "testuser");
mysql_select_db("mydb",$db);
- etc. -

and I get this error message:

Warning: Access denied for user 'testuser@localhost" (Using password: YES) in (location of request in document)
Warning: MySQL Connection Failed: Access denied for user 'testuser@localhost" (Using password: YES) in (location of request in document

BUT

if I change my query to
$db = msql_connect("localhost", "root", "rootpassword");
mysql_select_db("mydb",$db);
- etc. -

it works like a charm.

I was able to revoke all from testuser as well, so the user was created in the db. But I just can't get into the db with that user (or any other one I try to create/grant privileges to). Only "root" is working.

This is on a Mac G3 with OS X 10.1.5. I have a virtually identical installation of PHP, MySQL and Apache on a G4 running the same OS and it works like a charm.

What am I missing?

[hrosas]

Well first in your user query you should write something like:
mysql> grant all on mysqldb. to testuser@localhost identified by 'testuser';
this will add a user that have access from the localhost only, I think that's what you need. if you nedd access from other places you should use:
mysql> grant all on mysqldb. to testuser@'%' identified by 'testuser';
but use the first one. As you can see you never set a server for the user. Try again.

Hector.

http://www.oksonora.com OKsonora

[bunner_bob]

Ahh - very good. That fixes it.

Thank you.

Strange that it works fine without the "@" on my G4. Must be some different configuration somewhere in the whole PHP/MySQL/Apache mess.