首页 > 代码库 > mysql Lost connection to MySQL server at ‘reading initial communication packet
mysql Lost connection to MySQL server at ‘reading initial communication packet
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.1local-infile=0datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-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/Systemdskip-name-resolve
mysql Lost connection to MySQL server at ‘reading initial communication packet
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。