Mysql Error=>2003:Can‘t connect to MySQL server on ‘192.168.1.47‘ (111)
注释掉下面两个在my.cnf中
#skip_networking -- 跳过网络请求
#bind-address = 127.0.0.1 绑定IP
Mysql Error=>1130:Host ‘192.168.1.123‘ is not allowed to connect to this MySQL server
我用的是root 跟空密码
本地进入mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘‘ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO ‘用户名‘@‘IP终端终地址‘ IDENTIFIED BY ‘密码‘ WITH GRANT OPTION;
% 表示所有IP