http://blog.micxp.com/index.php/archives/113/
MySQL Remote connection error (HY000): Lost connection to MySQL server @ ' Waiting for initial communication packet ', system error:0 Error, the solution is as follows.
There is another problem, I also use the same method to solve is to use show processlists; viewing when the user becomes unauthenticated user
Modify the MySQL configuration file
VI / etc / my.cnf
[Mysqld] #加上下面的代码, note that the following code is best added to the first line of the [MYSQLD] paragraph. Because, the first time I add to the last line. Results The MYSQLD service cannot start. Skip - name - ResolveRestart MySQL Service mysqld Restart Note: Skip-name-resolve It will prevent MySQL Server from DNS parsing of external connections, and using this option can eliminate the time for DNS resolution for MySQL. However, it is important to note that if you turn on this option, all remote host connection authorizations will use IP address, otherwise MySQL will not be able to handle connection requests properly.
