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.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


This entry was posted in 数据库 and tagged . Bookmark the permalink.
月小升QQ 2651044202, 技术交流QQ群 178491360
首发地址:月小升博客https://java-er.com/blog/mysql-lost-connection/
无特殊说明,文章均为月小升原创,欢迎转载,转载请注明本文地址,谢谢
您的评论是我写作的动力

One Response to mysql Lost connection to MySQL server at ‘reading initial communication packet

  1. 都英文啊,看不太懂。。。

Leave a Reply

Your email address will not be published. Required fields are marked *

*

*

  

About Me

静水流深,水滴石穿