ERROR 1130: Host 192.168.1.23 is not allowed to connect to this MySQL server
在本机登入mysql后,更改 “mysql” 数据库里的 “user” 表里的 “host” 项,从”localhost”改称'%'即可
mysql -u root -p
输入自己的密码
mysql> use mysql;mysql> select 'host' from user where user='root';
mysql> update user set host = '%' where user ='root';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY' 不予理会
mysql> flush privileges;
重启mysql服务