user: Contains user accounts, global privileges, and other non-privilege columns. user: 用户帐号、全局权限
db: Contains database-level privileges. db: 库级别权限
host: Obsolete. host: 废弃
tables_priv: Contains table-level privileges. 表级别权限
columns_priv: Contains column-level privileges. 列级别权限
procs_priv: Contains stored procedure and function privileges. 存储过程和存储函数相关的权限
proxies_priv: Contains proxy-user privileges. 代理用户权限
权限级别:
全局级别: SUPER、
库
表: DELETE, ALTER, TRIGGER
列: SELECT, INSERT, UPDATE
存储过程和存储函数
临时表:内存表
heap: 16MB
触发器:主动数据库
INSERT, DELETE, UPDATE
user: log
忘记MySQL用户密码:编辑启动脚本start()中启动mysqld_safe时传递两个参数:
--skip-grant-tables:跳过授权表
--skip-networking
通过更新授权表方式直接修改其密码,而后移除此两个选项重启服务器。