连接MySQL
mysql -u root -p
use mysql;
查看Host列允许用户登录所使用的IP
select host from user where user='root';
修改
update user set host = '%' where user ='root';
查看是否修改
使配置生效
flush privileges;
连接MySQL
mysql -u root -p
use mysql;
查看Host列允许用户登录所使用的IP
select host from user where user='root';
修改
update user set host = '%' where user ='root';
查看是否修改
使配置生效
flush privileges;