
第一步,
x:\>mysql -u root -p***
mysql> use mysql;
mysql> select host, user from user; //看一下当前root用户的host设置
mysql> update user set host = ‘%’ where user = ‘root’;
mysql> select host, user from user; //确认下root用户的host设置是否修改
mysql> flush privileges; //使修改生效
第二部,检查防火墙3306端口