MySQL Workbench出现：Error Code: 2013. Lost connection to MySQL server during query的问题解决_mysql workbench lost connection to mysql server du

MySQL Workbench出现：Error Code: 2013. Lost connection to MySQL server during query

为30s报错的时候

按
@rabeen 说

按照网上的经验，修改mysql服务器的配置文件，my.ini的timeout时间，发现问题仍然存在。 
后来换mysql安装自带的cmd命令行客户端，没有超时问题。 怀疑是mysql workbench 客户端原因。 
后来再MySQL workbench Q&A找到原因，链接如下  https://dev.mysql.com/doc/workbench/en/workbench-faq.html#faq-workbench-error-lost-connection
Yes, go to Preferences, SQL Editor, and adjust the DBMS connection read time out option that defaults to 600 seconds. This sets the maximum amount of time (in seconds) that a query can take before MySQL Workbench disconnects from the MySQL server.
原文：https://blog.csdn.net/rabeen/article/details/78580861 
1
2
3
4
5

后来在https://stackoverflow.com/questions/15712512/mysql-workbench-how-to-keep-the-connection-alive
Go to Edit -> Preferences -> SQL Editor and set to a higher value this parameter: DBMS connection read time out (in seconds).