学习笔记(09):MySQL数据库从入门到搞定实战-权限管理(授予与回收)
立即学习:https://edu.****.net/course/play/27328/370704?utm_source=blogtoedu
使用grant命令授权、revoke命令撤销授权,这些命令要在root用户下执行
授权:
grant all privileges on databaseName.tableName to '用户名' [@'主机名']
all privileges为所有权限
撤销授权:
revoke all privileges on databaseName.tableName from '用户名' [@'主机名']
刷新权限:
flush privileges
进行授权或撤销授权后执行flush privileges立即生效
查看权限:
show grant for '用户名' [@'主机名']
权限分类:
例:
查看权限:
show grants for 'Nekonlaa'@'localhost';
+----------------------------------------------+
| Grants for [email protected] |
+----------------------------------------------+
| GRANT USAGE ON *.* TO `Nekonlaa`@`localhost` |
+----------------------------------------------+
赋予读权限(mydb库中的所有表):
grant select on mydb.* to 'Nekonlaa'@'localhost';