本文最后更新于 107 天前,其中的信息可能已经有所发展或是发生改变。
GRANT SUPER ON *.* TO '用户名'@'localhost';
GRANT SUPER ON *.* TO '用户名'@'127.0.0.1';
flush privileges;
REVOKE ALL PRIVILEGES ON *.* FROM 'pay'@'localhost'; REVOKE GRANT OPTION ON *.* FROM 'pay'@'localhost'; GRANT SUPER ON *.* TO 'pay'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
REVOKE ALL PRIVILEGES ON *.* FROM 'pay'@'127.0.0.1'; REVOKE GRANT OPTION ON *.* FROM 'pay'@'127.0.0.1'; GRANT SUPER ON *.* TO 'pay'@'127.0.0.1' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;