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