How to Resolve MySQL Error Code 2013: Lost Connection During Query?

Solving MySQL Error 2013: Lost Connection to Server

MySQL Workbench users often encounter "Error Code: 2013. Lost connection to MySQL server during query," especially with lengthy queries. This error halts database operations. Here's a solution:

Increase MySQL Workbench Timeouts

Newer MySQL Workbench versions let you customize timeout settings. Follow these steps:

1. Access the "Edit" menu in MySQL Workbench.
2. Choose "Preferences."
3. Navigate to "SQL Editor" > "DBMS connection."
4. Find "Read time out (in seconds)."
5. Raise the value (e.g., from 60 to 600 or even 6000) to accommodate longer queries.

Further Recommendations

Besides adjusting timeouts, consider these points:

• Disable Row Limiting: For large datasets, unchecking "Limit rows" can boost performance and avoid premature query termination.

This approach should resolve most instances of Error 2013.

The above is the detailed content of How to Resolve MySQL Error Code 2013: Lost Connection During Query?. For more information, please follow other related articles on the PHP Chinese website!