30.9.3 解除用户的资源限制

30.9.3　解除用户的资源限制

删除用户的资源限制时，只需要将相应的资源限制设置为0即可。例如，删除binghe_test的资源限制。

---

mysql> GRANT USAGE ON *.* TO 'binghe_test'@'localhost'
    -> WITH MAX_QUERIES_PER_HOUR 0
    -> MAX_UPDATES_PER_HOUR 0
    -> MAX_USER_CONNECTIONS 0;
Query OK, 0 rows affected, 1 warning (0.00 sec)

---

SQL语句执行成功，查看binghe_test用户的资源限制情况。

---

mysql> SELECT user, host, max_questions, max_updates, max_user_connections
    -> FROM mysql.user WHERE user = 'binghe_test' AND host = 'localhost';
+-------------+-----------+---------------+-------------+----------------------+
| user        | host      | max_questions | max_updates | max_user_connections |
+-------------+-----------+---------------+-------------+----------------------+
| binghe_