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. Increase the "Command Timeout" value for your MySQL connection:

    • Go to the Connections page and select your MySQL connection.
    • Click Edit.
    • In the connection editor, go to Advanced, then increase the value for the Command Timeout property.

  2. 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.