#给用户UserName赋予所有库的所有权限
GRANT ALL PRIVILEGES ON *.* TO 'UserName'@'%' IDENTIFIED BY 'Passwd' WITH GRANT OPTION;
#重新载入赋权表
FLUSH PRIVILEGES;
#移除权限(不包含赋权权限)
REVOKE ALL PRIVILEGES ON *.* FROM UserName;
REVOKE ALL PRIVILEGES ON DataBase.* FROM UserName;
#移除授权的权限
REVOKE GRANT OPTION ON *.* FROM UserName;
#重新载入赋权表
FLUSH PRIVILEGES;
转载请注明原文地址: https://www.6miu.com/read-69156.html
