第12章 mysql系统库之权限系统表 - xiaoboluo768/qianjinliangfang GitHub Wiki

12.1 user

mysql> select * from mysql.user limit 1\G;
......
1 row in set (0.00 sec)

12.2 db

mysql> select * from db limit 1\G
......
1 row in set (0.00 sec)

12.3 tables_priv

mysql> select * from tables_priv\G
......
1 row in set (0.00 sec)

12.4 columns_priv

mysql> select * from columns_priv\G
......
1 row in set (0.00 sec)

12.6 proxies_priv

mysql> select * from proxies_priv\G
......
1 row in set (0.00 sec)

上一篇:第11章 information_schema应用示例荟萃 | 下一篇:第13章 mysql系统库之访问权限控制系统