30.9.1 限制用户使用资源示例
例如,为binghe_test用户授予goods数据库上的查询和更新权限,并且每小时的查询次数最多为100,每小时的更新次数最多为20,使用binghe_test用户最多同时有10个并发连接。
mysql> GRANT SELECT, UPDATE ON goods.* TO 'binghe_test'@'localhost'
-> WITH MAX_QUERIES_PER_HOUR 100
-> MAX_UPDATES_PER_HOUR 20
-> MAX_USER_CONNECTIONS 10;
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 |
+-------------+-----------