MySQL Workbench performs complex operations on large tables as follows: Error Code: 2013. Lost connection to MySQL server during query
Solutions:
Edit-> Preference-> SQL Editor
Appropriately increase the FOLLOWING DBMS Connection Read Time out(in seconds) :
![]()
Solutions:
Edit-> Preference-> SQL Editor
Appropriately increase the FOLLOWING DBMS Connection Read Time out(in seconds) :
Resources:
http://bbs.csdn.net/topics/391881939?page=1
https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html
Read More:
- 【Exception】mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table…
- [MySQL] the solution of MySQL workbench “error code: 1175”
- MySQL Workbench Failed to Connect to MySQL at 127.0.0.1:3306 with user root Bad handshake
- MySQL: if the remote connection using navicatip fails, prompt “is not allowed to connect to this MySQL server”
- MySQL local connection Error 1130_ The solution of MySQL 1130 error report when remote connection through Navicat for MySQL
- Solution to MySQL workbench error 1148 unable to load local data
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used
- It can’t connect to local MySQL server through socket ‘/ tmp/ mysql.sock ‘(2) “;
- iOS Frequent Error Domains = NSURLErrorDomain Code = -1005 “Network Connection Lost.”
- PHP connection to MySQL database error: call to undefined function MySQL_ connect()
- [How to Fix] MySQL Workbench for Mac Flashback
- How to Solve MacOS Big Sur MySQL workbench flashback problem
- node.js Server MySQL database connection timeout (error: connect etimeout)
- The MySQL service suddenly hangs up with the error message can’t connect to MySQL server on ‘localhost’ (10061)
- “No nodes available to run query” is reported when using Presto to connect to MySQL query“
- Sqlog connect to MySQL 8.0.24 remote server, error: 2058 solution
- After installing MySQL again under Linux, the solution of ‘MySQL module failed to start’ appears
- When MySQL is running, the server suddenly goes down, which causes Mysql to be unable to restart
- (error when importing database): MySQL 2006-mysql server has gone away
- Error Code: 2006 – MySQL server has gone away