1,查看所有用户权限
select distinct concat('User:''',user,'''@''',host,''';') AS query from mysql.user;
或者:
select * from mysql.user;
2,查看某一个用户的权限
show grants for 'user'@'ip';
3,分配权限(以selcet权限为例)
--无须密码
grant select on *.* to 'user'@'ip';
--指定密码(xxxx为密码)
grant select on *.* to 'user'@'ip'identified by 'xxxx';
4,回收权限
revoke select on *.* from 'user'@'ip'identified by 'xxxx';
--暴利删除某用户的所有权限
delete from mysql.user where User='user'
5,刷新权限,否则不生效
flushprivileges;
附,查看当前端口
show global variables like 'port';
宵云网络科技 www.tfyum.net webtfyum.net
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31554777/viewspace-2284612/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31554777/viewspace-2284612/