mysql 添加权限和撤销权限的实例(亲测可行)

将当前数据库的表role_modules 的select权限赋予给用户uwangq:

GRANT SELECT ON role_modules TO uwangq@'%' IDENTIFIED BY "uwangq";
FLUSH PRIVILEGES;

将当前数据库的表role_modules 的select权限从用户uwangq上撤销:

REVOKE SELECT ON role_modules FROM uwangq@'%' IDENTIFIED BY "uwangq";
FLUSH PRIVILEGES;

上一篇:[code3119]高精度练习之大整数开根


下一篇:继承,多态,集合,面向对象,XML文件解析,TreeView动态加载综合练习----->网络电视精灵项目练习、分析