ecs里的数据库访问不到 message from server: “Host ‘115.27.212.170‘ is not allowed to connect to this MySQL se

ecs里的数据库访问不到

message from server: "Host '115.27.212.170' is not allowed to connect to this MySQL server".

 

 

CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

所以数据库密码就变成了some_pass

 

....

 

 

如何删除数据库的用户

 

#select * from mysql.user;

#select host from mysql.user;

#DROP USER 'root'@'ip_address';

#DROP USER 'root'@'%';
#select user,host from mysql.user;

#CREATE USER 'root'@'%' IDENTIFIED BY '12345';
#select user,host from mysql.user;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';