MySQL 一键收回用户所有权限

1. mysql> show grants for gltest@localhost;
   
2. +-----------------------------------------------------+
   
3. | Grants for gltest@localhost |
   
4. +-----------------------------------------------------+
   
5. | GRANT ALL PRIVILEGES ON *.* TO 'gltest'@'localhost' |
   
6. | GRANT SELECT ON `orcl`.* TO 'gltest'@'localhost' |
   
7. +-----------------------------------------------------+
   
8. 2 rows in set (0.00 sec)
   
9. 
   
10. mysql> revoke all,grant option from gltest@localhost;
    
11. Query OK, 0 rows affected (0.00 sec)
    
12. 
    
13. mysql> show grants for gltest@localhost;
    
14. +--------------------------------------------+
    
15. | Grants for gltest@localhost |
    
16. +--------------------------------------------+
    
17. | GRANT USAGE ON *.* TO 'gltest'@'localhost' |
    
18. +--------------------------------------------+
    
19. 1 row in set (0.00 sec)

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

转载于:http://blog.itpub.net/20893244/viewspace-2148787/