30.8.2 使用DELETE语句删除用户

30.8.2　使用DELETE语句删除用户

例如，使用DELETE语句删除binghe_test用户。

---

mysql> DELETE FROM mysql.user WHERE user = 'binghe_test' AND host = 'localhost';
Query OK, 1 row affected (0.00 sec)

---

SQL语句执行成功，查看MySQL中是否还存在binghe_test用户。

---

mysql> SELECT * FROM mysql.user WHERE user = 'binghe_test' AND host = 'localhost';
Empty set (0.00 sec)

---

查询结果为空，说明binghe_test用户已经被删除。