[Resolved] Mac OS X (Panther) - can't connect except as "root"

[bunner_bob]

I've granted access permissions to all my tables, using the (presumed correct) syntax:

grant select, insert, update, delete on mydb.table to dbadmin identified by 'adminpassword';

and so on for each table. The sql commands are accepted and when I check, the proper username and table are in the mysql database, "tables_priv" table.

But, I still can only connect to my database using the "root" user and root password. I.E. - this works:

$db = mysql_connect("localhost", "root", "rootpassword");
mysql_select_db('mydb');

but this doesn't:

$db = mysql_connect("localhost", "dbadmin", "adminpassword");
mysql_select_db('mydb');

This all used to work fine, but since I upgraded to "Panther" (10.3) it doesn't, and I must connect as the root user.

Any ideas why this might be, what I should check, etc.?

Thanks,
Bob

[bunner_bob]

Solved - thanks to MacOSX.com.

I needed to be granting permission to "dbadmin@localhost" instead of just "dbadmin" - I wasn't specifying the host.

Apparently I was able to get away with this in some prior version of MySQL, but at some point I upgraded and the new version wouldn't accept it.

Either that or OSX Panther is pickier.

• Bob