mysql中授予最高权限

Question

要求用grant授予用户每小时最多查询一次的权限
mysql> GRANT ALL PRIVILEGES ON . TO 'a1' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 1;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAX_QUERIES_PER_HOUR 1' at line 1

想问问错在哪里呢 用同样的方式授予每小时更新次数也是一样报错了

Answer 1

GRANT SELECT ON test.*
TO 'a1'@'%'
WITH MAX_QUERIES_PER_HOUR 1;