mysql如何回收用户权限_mysql 用户权限回收

mysql 用户权限回收

show grants for 'monitor'@'%';

+--------------------------------------------------------------------------------------------------------+

| Grants for monitor@%                                                                                   |

+--------------------------------------------------------------------------------------------------------+

| GRANT USAGE ON *.* TO 'monitor'@'%' IDENTIFIED BY PASSWORD '*8E043332BD6AAC61C53AE3D835FFF316F00337CC' |

| GRANT EXECUTE ON "test".* TO 'monitor'@'%'                                                             |

| GRANT ALL PRIVILEGES ON "monitor".* TO 'monitor'@'%'                                                   |

| GRANT SELECT ON "performance_schema".* TO 'monitor'@'%'                                                |

+--------------------------------------------------------------------------------------------------------+

REVOKE ALL PRIVILEGES ON "monitor".* from 'monitor'@'%' ;

grant delete,update,insert,select on "monitor".* TO 'monitor'@'%' ;

flush privileges;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/91975/viewspace-2106730/，如需转载，请注明出处，否则将追究法律责任。