(mysql.info.gz) Privilege changes

Info Catalog

(mysql.info.gz) Request access

(mysql.info.gz) Privilege system

(mysql.info.gz) Access denied

 
 5.5.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 will have _no effect_ until you restart the server.  This may
 leave you wondering why your changes don't seem to make any difference!
 

Info Catalog

(mysql.info.gz) Request access

(mysql.info.gz) Privilege system

(mysql.info.gz) Access denied