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?

Can you file a bug report (http://bugs.mysql.com), so this gets solved properly? — Mike Lischke, Mar 23 '16 at 07:55

score 0 · Answer 1 · edited May 23 '17 at 11:50

0

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

edited May 23 '17 at 11:50

Community

answered Mar 22 '16 at 17:05

gsc_dba

This is not a server issue, but rather a Workbench issue. I am connecting to Bluehost public hosting MySQL server so I am not able to change any server settings. And everything was working just fine in my previous Workbench version running on Win 8.1. – gdolenc Mar 23 '16 at 06:34

score 0 · Accepted Answer · answered Mar 23 '16 at 07:30

0

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

answered Mar 23 '16 at 07:30

gdolenc

2 Answers2