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'@'%';