ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 102
If your MySQL service suddenly stopped accepting connections and you receive an error trying to connect to your MySQL server instance, try to increase the connect_timeout variable in the my.cnf file shown below. For more information, refer to the MySQL documentation here.
MySQL Error message:
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 102
The suggested value to apply is 10 seconds. You can increase to 30 seconds or higher if you continue to receive the error. In addition, you should increase the table_open_cache limit to something less than 1000. See this article for more details.
In my.cnf file, add:
connect_timeout = 10
table_open_cache = 900
Restart MySQL.
Comments