可以使用下面的命令在系统中进行赋权,这个命令能将所有权限赋给用户。GRANT USAGE ON * . * TO 'demo.ossez.com'@'%' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;程序执行如下:
GRANT USAGE ON * . * TO 'demo.ossez.com'@'%' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;