mysql 回收权限

 

mysql> show grants for qfedu@'192.168.152.%';         查看某个用户的权限，下面回显表示没有任何权限+-----------------------------------------------+| Grants for qfedu@192.168.152.% |+-----------------------------------------------+| GRANT USAGE ON *.* TO 'qfedu'@'192.168.152.%' |+-----------------------------------------------+1 row in set (0.00 sec)

mysql> grant select,drop,insert on qfedu.* to 'qfedu'@'192.168.152.%';    给qfedu这个用户(只能从192.168.152.x网段登录)对qfedu数据库中的所有表有查询，删除，插入的权限Query OK, 0 rows affected (0.00 sec)

mysql> show grants for qfedu@'192.168.152.%';         此时在查看多了一些权限+--------------------------------------------------------------------+| Grants for qfedu@192.168.152.% |+--------------------------------------------------------------------+| GRANT USAGE ON *.* TO 'qfedu'@'192.168.152.%' || GRANT SELECT, INSERT, DROP ON `qfedu`.* TO 'qfedu'@'192.168.152.%' |+--------------------------------------------------------------------+2 rows in set (0.01 sec)

mysql> revoke select on qfedu.* from qfedu@'192.168.152.%';        回收select权限从qfedu数据库里面的所有表从qfedu@'192.168.152.%'用户Query OK, 0 rows affected (0.00 sec)

 回收所有权限

 回收部分权限

 记得刷新授权表