This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › MySQL › Error Code: 2013. Lost connection to MySQL server du ...
View: 15703|Reply: 1

[Tips] Error Code: 2013. Lost connection to MySQL server during query

[Copy link]
Posted on 5/11/2018 3:38:00 PM | | | |
Error Code: 2013. Lost connection to MySQL server during query

MySQL version: 5.7.21

The error is reported by MySQL query analyzer as above:

Many of the solutions available online are modification my.ini

max_allowed_packet = 500M

It's really a dog, it's not right at all, and most of the people on the Internet say that it's solved like this, drunk...

Correct solution

The new version of MySQL WorkBench has the option to change a specific timeout, the default time is 30 seconds,

MySQL WorkBench settings Edit → Preferences → SQL Editor → DBMS connection read time out (in seconds): 600

The timeout is 600 seconds, as shown in the figure below:







Previous:When using MySQL to process more than one million levels of data, there are a few common senses that must be known
Next:AI data sharing

Related Posts
 Landlord| Posted on 5/11/2018 4:31:16 PM |
MySQL Memory Calculator

http://www.mysqlcalculator.com/
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com