1 查看用户权限信息;
mysql> show grants for 'root'@'%';
+----------------------------------+
| Grants for root@% |
+----------------------------------+
| GRANT USAGE ON *.* TO `root`@`%` |
+----------------------------------+
1 row in set (0.00 sec)
select privileges_list from mysql.user where user='root' and host='%';
使用revoke 收回权限