Hi, Yes, you're right. GRANT and REVOKE do not need FLUSH PRIVILEGES afterwards. Flushing is only needed when manually updating the grant tables via normal INSERT/UPDATE/DELETE commands.
Regards, Iikka On Wed, 2 Oct 2002 [EMAIL PROTECTED] wrote: > If i use GRANT and REVOKE to change user privileges, it is my understanding > that i don't have > to issue a FLUSH PRIVILEGES statement. > Is this correct? > > Our sysadmin rebooted the MySQL server this morning, and there were some > privilege problems > afterward. I had to reset the privileges for some mysql users. > The only thing i can think of is that there were some pending privilege > changes that > were read by mysqld for the first time when the server restarted. > > any other theories about why this would happen? > > regards, > sean peters > [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- > 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 > ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- 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