MySql ERROR 2013:Lost connection to MySQL

Mysql Workbench执行长时间数据库操作时出现:MySql ERROR 2013:Lost connection to MySQL。

修改Mysql Workbench参数解决:

Edit->Perferences->SQL Editor:


DBMS connection keep-alive interval(in seconds) :600000 


DBMS connection read timeout interval(in seconds) : 600000


DBMS connection timeout interval(in seconds) : 600000

三个参数值根据实际情况作大小调整。

MySQL error :2013 Lost connection to MySQL