mysql-workbench - mysql workbench 经常丢失连接

Question

直接用 mysql workbench 连接的外网的 mysql。
经常在简单查询的时候，遇到

Error Code: 2013. Lost connection to MySQL server during query

一般几分钟不动，再去查询时就会遇到

已经将 Edit -> Perferences --> other --> SSH KeepAlive 设置为 10
其实连接使用的是 TCP/IP 没有和 SSH 产生关联，但是设置里面只有这项

Answer 1

This problem becomes more prominent after the VPN is hung up. After I don’t operate it for a long time, I usually just log out and then reconnect.