mysql 爆出,本地连接正常,远程链接无法链接,爆出错误
Lost connection to MySQL server at ‘reading initial communication packet
大量无法远程链接的问题
1.iptables 导致 看看iptables -L
2.mysqld 下增加
skip-name-resolve
我加了发现不行
看下面
3.bind-adress
我发现mysqld 还有一句
bind-address = ::ffff:127.0.0.1
[mysqld] #bind-address = ::ffff:127.0.0.1 local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 # Settings user and group are ignored when systemd is used. # If you need to run mysqld under a different user or group, # customize your systemd unit file for mariadb according to the # instructions in http://fedoraproject.org/wiki/Systemd skip-name-resolve