How to configure the connection time out in MySQL Workbench

Go to Edit -> Preferences -> SQL Editor and set to a value of the parameters:

DBMS connection keep-alive interval
DBMS connection read time out

If you are using a "Standard TCP/IP over SSH" type of connection, it might be the ssh server that keeps timing out, in which case, you would have to edit TCPKeepAlive related settings in /etc/ssh/sshd_config on your server.

Comments

Popular posts from this blog

Check MySQL query history from command line