mysql查询所有用户以及权限相关

select distinct concat('User:''',user,'''@''',host,''';') AS query from mysql.user;

grant select,update,insert,delete on *.* to root@192.168.1.133 identified by "root";

select host,user.password from user;

 

posted on 2013-06-24 00:40  awk  阅读(178)  评论(0)    收藏  举报

导航