MySQL Workbench: How to keep the association alive

Follow the underneath steps to keep the association alive:

Step 1: Go to Edit

Step 2: Select Preferences

Step 3: Go to SQL Editor and set to a higher value this parameter: DBMS connection read time out (in seconds). For instance: 86400.

Step 4: Close and reopen MySQL Workbench. Kill your previous query that probably is running and run the query again.

For more information, you can refer to :

https://web.archive.org/web/20130322031356/http://www.hassmann-software.de/mysql-workbench-lost-connection-to-mysql-server-after-600-second