On Wednesday 28 September 2005 10:19 pm, Brad Dameron wrote:
Privilege changes do not take plush until the server is restarted or you issue a 'flush privileges' command.
Scott
This is all incorrect. Priviledges from within MySQL are instantaneous. The problem is your formating:
I stand corrected. You are right, when using GRANT the changes are noticed by the server..... 5.7.7. When Privilege Changes Take Effect When mysqld starts, all grant table contents are read into memory and become effective for access control at that point. When the server reloads the grant tables, privileges for existing client connections are affected as follows: Table and column privilege changes take effect with the client's next request. Database privilege changes take effect at the next USE db_name statement. Changes to global privileges and passwords take effect the next time the client connects. If you modify the grant tables using GRANT, REVOKE, or SET PASSWORD, the server notices these changes and reloads the grant tables into memory again immediately. If you modify the grant tables directly using statements such as INSERT, UPDATE, or DELETE, your changes have no effect on privilege checking until you either restart the server or tell it to reload the tables. To reload the grant tables manually, issue a FLUSH PRIVILEGES statement or execute a mysqladmin flush-privileges or mysqladmin reload command. If you change the grant tables directly but forget to reload them, your changes have no effect until you restart the server. This may leave you wondering why your changes don't seem to make any difference Scott -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.11.4-21.9-default x86_64 SuSE Linux 9.3 (x86-64)