At 16:57 -0700 7/4/05, l'eau@stripped wrote:
>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.
You assigned database-level privileges, which are recorded in mysql.db,
>What could possibly be preventing the system from changing the GRANT
>Is the mysql.db table part of the granting?
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com