看图一幕了然 ,看不懂向下看案例
案例 下面名命令行....
mysql> create user lianshanzhouyi@'%' identified by
# 创建lianshanzhouyi用户
Query OK, 0 rows affected (0.01 sec)
mysql> grant all on *.* to lianshanzhouyi@'%';
# 授权lianshanzhouyi所有权限 all 代表所有
Query OK, 0 rows affected (0.02 sec)
mysql> select * from mysql.user where user='lianshanzhouyi'\G
# 查看lianshanzhouyi权限信息
*************************** 1. row ***************************
Host: %
User: lianshanzhouyi
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y # 注意Delete权限Y是拥有改权限 下面回收权限
Create_priv: Y
Drop_priv: Y
Reload_priv: Y
Shutdown_priv: Y
Process_priv: Y
File_priv: Y
Grant_priv: N
1 row in set (0.00 sec)
mysql> revoke delete on * . * from lianshanzhouyi@'%';
# 回收lianshanzhouyi的Delete(删除)权限
Query OK, 0 rows affected (0.01 sec)
mysql> select * from mysql.user where user='lianshanzhouyi'\G
*************************** 1. row ***************************
Host: %
User: lianshanzhouyi
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: N # 成功回收Delte权限 没有权限为N
Create_priv: Y
Drop_priv: Y
Reload_priv: Y
Shutdown_priv: Y
Process_priv: Y
File_priv: Y
Grant_priv: N
References_priv: Y
1 row in set (0.00 sec)