Host is not allowed to connect t
2022-03-27 本文已影响0人
花伤情犹在
方法1：
mysql>use mysql;
mysql>update user set host = '%' where user = 'root';
mysql>select host, user from user;
方法2：
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
mysql>flush privileges;
说明：%是哪个IP地址可以访问这个MYsql服务，可以换成你想要的IP地址！
