一、相关命令汇总

USE mysql
UPDATE USER SET user='test' WHERE user = ''
GRANT ALL ON *.* TO 'jerry'@'%' IDENTIFIED BY 'mypass'
FLUSH PRIVIELEGES
SELECT USER();
SHOW GRANTS

?

二、实际问题汇总
3.1 如何限制每小时每位用户的最大连接次数

GRANT ALL ON test.* TO 'admin'@'%' WITH MAX_QUERIES_PER_HOUR 1000 MAX_CONNECTIONS_PER_HOUR 100;