MySQL: Resolving "Lost connection to MySQL server during query" Error

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:
  1. Go to the Connections page and select your MySQL connection.
  2. Click Edit.
  3. 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:
  1. max_allowed_packet
  2. net_read_timeout
  3. net_write_timeout

For detailed information, please refer to the MySQL documentation: MySQL Server System Variables.