快速解決mysql Lost connection to MySQL server at 'reading initial communication packet及can't connect to mysql server on 'localhost'，

快速解決mysql Lost connection to MySQL server at 'reading initial communication packet及can't connect to mysql server on 'localhost'，

今天在使用Navicat連一個遠程mysql時，總是提示連接不成功，提示Lost connection to MySQL server at 'reading initial communication packet

但mysql服務已經啟動

百度查之，終於找到解決方法如下：

修改hosts.allow

vi /etc/hosts.allow
#加mysqld : ALL : ALLOW
mysqld-max : ALL :ALLOW

再次連接，但又提示can't connect to mysql server on 'localhost'，再次百度查之，得出下面結論：

在my.ini中沒有bind-address = 127.0.0.1的參數

但在服務器上查了半天都沒找到my.ini文件。

再次查看mysql日志：

裡面這這麼一段：

151213 17:05:35 InnoDB: 5.5.37 started; log sequence number 16568257
151213 17:05:35 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
151213 17:05:35 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
151213 17:05:35 [Note] Server socket created on IP: '0.0.0.0'.
151213 17:05:35 [Note] Event Scheduler: Loaded 0 events

忽然大悟，直接在Navicat中改變連接屬性：

連接成功

參考資源：

1、http://blog.sina.com.cn/s/blog_4cd14afb01012eox.html

2、http://blog.csdn.net/chengwenyao18/article/details/24112997