设置允许IP访问,执行语句
select host,user from mysql.user;
update mysql.user set host = '%' where user = 'root';
运行完上面的语句之后,再次执行 select host,user from mysql.user; 确认结果
flush privileges;
测试:连接成功
设置允许IP访问,执行语句
select host,user from mysql.user;
update mysql.user set host = '%' where user = 'root';
运行完上面的语句之后,再次执行 select host,user from mysql.user; 确认结果
flush privileges;
测试:连接成功