OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: GRANT and mysql.user table

From: Paul DuBois (paulmysql.com)
Date: Mon Jul 04 2005 - 19:06:58 CDT

At 16:57 -0700 7/4/05, l'eaumediacult.com 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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql