连接Mysql报错lost connection to MySQL server at "waiting for initial communication packet

打开了3306端口,设置了user表host为'%',依然无法连接,telnet 3306端口不同,原因是配置文件中设置了 bind-address: 127.0.0.1,(/etc/mysql/mysql.conf.d/sqld.cnf )把他注释掉,端口能连上,但是又报下面的错误

lost connection to MySQL server at "waiting for initial communication packet

在 /etc/mysql/mysql.conf.d/sqld.cnf 文件中增加 skip-name-resolve 就可以连接了

posted @ 2018-11-01 21:47  美好时光Jeff  阅读(3006)  评论(0编辑  收藏  举报