30.9.2 修改用户的资源限制
将binghe_test用户每小时的查询次数限制修改为200,将每小时的更新次数限制修改为50。
mysql> GRANT USAGE ON *.* TO 'binghe_test'@'localhost'
-> WITH MAX_QUERIES_PER_HOUR 200
-> MAX_UPDATES_PER_HOUR 50;
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_test | localhost | 200 | 50 | 10 |
+-------------+-----------+---------------+-------------+----------------------+
1 row in set (0.00 sec)
可以看到,binghe_test用户每小时的查询次数限制已经被修改为200,每小时的更新次数限制已经被修改为50。