1、远程连接 mysql 报错
ERROR 1130 (HY000): Host '192.168.1.111' is not allowed to connect to this MySQL server
2、允许登录
(1)改表法。
默认不允许从远程登陆,只能在 localhost。更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从 "localhost" 改称 "%"。
mysql -u root -p123
use mysql;
update user set host = '%' where user = 'root';
select host, user from user;
(2)授权法
grant all privileges on *.* to 'mysql'@'%' identified by '123' with grant option;
(3)重启服务
3、开放端口
开放防火墙,windows 则添加入栈规则。