Workbench 6.3 on Windows 10

Question

I have a problem with Workbench 6.3 on my Win 10 machine. When I open WB and run a query after idle for about a minute, I get an error:

Error Code: 2006. MySQL server has gone away
Error Code: 2013. Lost connection to MySQL server during query

I have set DBMS connection keep-alive interval, read time out and connection time out to 3600 seconds, but the problem still persists.

Any idea?

Answer 1

It looks like it is Workbench 6.3.6 issue. Once I downgraded to 6.3.4 everything is working as it should.

Answer 2

Please check the packet size contents of /etc/my.cnf that corrected this issue for me below:

[mysqld]
max_allowed_packet= 64M
wait_timeout= 6000

There is also another Q&A for your error code here: Getting MYSQL Error: "Error Code: 2006 - MySQL server has gone away"