columns_priv Column privileges db Database privileges event Events func User defined functions general_log General log help_category help categories help_keyword help keywords help_relation keyword-topic relation help_topic help topics host Host privileges; Merged with database privileges ndb_binlog_index plugin MySQL plugins proc Stored Procedures procs_priv Procedure privileges servers MySQL Foreign Servers table slow_log Slow log tables_priv Table privileges time_zone Time zones time_zone_leap_second Leap seconds information for time zones time_zone_name Time zone names time_zone_transition Time zone transitions time_zone_transition_type Time zone transition types user Users and global privileges
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| event |
| func |
| general_log |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| servers |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
23 rows in set (0.00 sec)mysql>你看这些表名称,应该也能猜得个8,9成了吧。
user 用户 proc 存储程序 event 计划任务
主要权限、时区、表information,你一个表一个表的在google上搜索呗
db Database privileges
event Events
func User defined functions
general_log General log
help_category help categories
help_keyword help keywords
help_relation keyword-topic relation
help_topic help topics
host Host privileges; Merged with database privileges
ndb_binlog_index
plugin MySQL plugins
proc Stored Procedures
procs_priv Procedure privileges
servers MySQL Foreign Servers table
slow_log Slow log
tables_priv Table privileges
time_zone Time zones
time_zone_leap_second Leap seconds information for time zones
time_zone_name Time zone names
time_zone_transition Time zone transitions
time_zone_transition_type Time zone transition types
user Users and global privileges