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;
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;