List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 5 2005 12:06am
Subject:Re: GRANT and mysql.user table
View as plain text  
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,
not mysql.user.

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

Yes.

Recommended reading:

http://dev.mysql.com/doc/mysql/en/privilege-system.html
http://dev.mysql.com/doc/mysql/en/user-account-management.html

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
GRANT and mysql.user tablel'eau@mediacult.com5 Jul
  • Re: GRANT and mysql.user tableMichael Stassen5 Jul
  • Re: GRANT and mysql.user tablePaul DuBois5 Jul