MySQL permissions are stored in corresponding tables : mysql Table « Data Dictionary « MySQL Tutorial






  1. MySQL Tutorial
  2. Data Dictionary
  3. mysql Table
columns_privcolumn privileges within a table
dbprivileges for the databases
funcprivileges for functions
hostprivileges for the hosts
tables_privindividual column privileges for a table
userprivileges for the access by users


In each table privileges for uses are set by 'Y' or 'N' in the appropriate column for a privilege.

mysql>
mysql> SELECT Host, Db, User, Select_priv
    -> FROM db WHERE (DB = "test");
mysql>








25.9.mysql Table
25.9.1.A bit about the 'mysql' database.
25.9.2.MySQL permissions are stored in corresponding tables