#给用户cacti赋予所有库的所有权限
GRANT ALL PRIVILEGES ON *.* TO 'cacti'@'%' IDENTIFIED BY 'cacti' WITH GRANT OPTION;
#重新载入赋权表
FLUSH PRIVILEGES;
#收回权限(不包含赋权权限)
REVOKE ALL PRIVILEGES ON *.* FROM cacti;
REVOKE ALL PRIVILEGES ON cacti.* FROM cacti;
#收回赋权权限
REVOKE GRANT OPTION ON *.* FROM cacti;
#重新载入赋权表
FLUSH PRIVILEGES;
————————————————
版权声明:本文为CSDN博主「guoxu775」的原创文章,遵循CC 4.0 by-sa版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/guoxu775/article/details/7701513