MySQL: Resolving "Lost connection to MySQL server during query" Error
To resolve the "Lost connection to MySQL server during query" error, please follow the steps below:
-
Go to the Connections page and select your MySQL connection.
- Click Edit.
- In the Connection Editor, go to Advanced, then increase or set to 0 the values for the "Command Timeout" and "Connection Timeout" properties.
Also, increase the following parameters on your MySQL server:
-
max_allowed_packet
- net_read_timeout
- net_write_timeout