查看MYSQL数据库中所有用户
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
给操作IP复权
insert into mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) values("11.11.11.11","hive",password("1231231231"),"","","");
flush privileges;