Mysql授权与撤权

给用户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;