30.6.2 通过操作数据表撤销用户权限

30.6.2　通过操作数据表撤销用户权限

本节以撤销binghe_test用户的权限为例进行简单说明。例如，通过修改mysql.user数据表的权限字段的值来撤销binghe_test用户对所有数据表的修改权限。

---

mysql> UPDATE mysql.user SET update_priv = 'N' WHERE user = 'binghe_test' AND host = 'localhost';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

---

SQL语句执行成功，查看binghe_test用户的权限。

---

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> SHOW GRANTS FOR 'binghe_test'@'localhost';
+----------------------------------------------------------+
| Grants for binghe_test@localhost                         |
+----------------------------------------------------------+
| GRANT SELECT, INSERT ON *.* TO 'binghe_test'@'localhost' |
+------------------------------------------