I tried as root having GRANT ALL PRIVILEGES with GRANT OPTION
to change the privilege of a user:
GRANT ALL ON mydb.*  TO myUser;

The result of this statement is that the query is OK and 0 rows are affected.
WHen I look at the mysql table holding the grants: user, the myUser row is unchanged.

What could possibly be preventing the system from changing the GRANT of myUser?
Is the mysql.db table part of the granting?

thanks in advance for your help.
laurie

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to