Yes, I've read this a number of times too. I've also read the section that says "If you use GRANT, you don't need to use FLUSH PRIVILEGES."
The way that I read this is that GRANT is the "automatic" method, not requiring FLUSH PRIVILEGES, whereas modifying the tables directly, using INSERT, UPDATE, etc. does require the use of FLUSH PRIVILEGES. Here's the proof: www:~ # mysql -p mysql mysql> grant all on zope.* to zope identified by "ccpzope"; Query OK, 0 rows affected (0.01 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.02 sec) mysql> select * from user where user="zope"; +------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ | Host | User | password | Select_priv | Insert_priv | Update_priv | |Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | |File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ | % | zope | 34577362486f3680 | N | N | N | N | | N | N | N | N | N | N || N | N | N | N | +------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ 1 row in set (0.01 sec) mysql> Thanks for trying to give me a hand. I'm open to other suggestions. -Kevin Zembower >>> Chris Cooper <[EMAIL PROTECTED]> 11/14/01 02:46PM >>> http://www.mysql.com/doc/P/r/Privilege_changes.html "If you modify the grant tables manually (using INSERT, UPDATE, etc.), you should execute a FLUSH PRIVILEGES statement or run mysqladmin flush-privileges or mysqladmin reload to tell the server to reload the grant tables. Otherwise your changes will have no effect until you restart the server. If you change the grant tables manually but forget to reload the privileges, you will be wondering why your changes don't seem to make any difference!" HTH, -- coop On Wed, 2001-11-14 at 13:29, KEVIN ZEMBOWER wrote: > I'm certain I'm making a simple mistake here, but can't find it. Here's what I'm >executing, using mysql 3.23.43-log: > > [I'm root when I run this] > #mysql -p mysql > mysql> grant all on zope.* to zope identified by "xxxxxxx"; > Query OK, 0 rows affected (0.00 sec) > > mysql> select * from user where user="zope"; > >+------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ > | Host | User | password | Select_priv | Insert_priv | Update_priv | >Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | >File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | > >+------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ > | % | zope | 34577362486f3680 | N | N | N | N > | N | N | N | N | N | N > | N | N | N | N | > >+------+------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ > 1 row in set (0.00 sec) > > mysql> > > My questions: > 1. Why didn't this work? > 2. If it had worked, would I have seen something other than "zero records affected" >in response to the GRANT command? > > I search the recent messages on GRANT and found the suggestion to run >mysql_fix_privilege_tables. It seemed to run correctly, but didn't change anything. > > Thanks for helping this newbie. > > -Kevin Zembower > > ----- > E. Kevin Zembower > Unix Administrator > Johns Hopkins University/Center for Communications Programs > 111 Market Place, Suite 310 > Baltimore, MD 21202 > 410-659-6139 > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
