错误:ERROR 1130: Host ‘192.168.1.3’ is not allowed to connect to thisMySQL serve
错误1130:主机192.168.1.3”不允许连接到thismysql服务
原因:被连接的数据不允许使用 192.168.1.3访问,只允许是用 localhost;
1.cmd
2.mysql -u -root -p
3.use mysql;
4.select ‘host’ from user where user=‘root’;
5.update user set host = ‘%’ where user =‘root’;
6.flush privileges;
7.select ‘host’ from user where user=‘root’;
运行完毕后再次连接测试,若还不行重启mysql,还不行重启电脑