MySQL Workbench: Reconnecting to database when "MySQL server has gone away"?

mysql-workbench
BugHunterUK picture BugHunterUK · Feb 8, 2016 · Viewed 17.8k times · Source

I have a lot of tabs and queries open in MySQL workbench. I left it open before I went to sleep, but this morning I am getting an error MySQL server has gone away when trying to run queries.

The database is up, and I am able to connect to it if I open a new connection on MySQL workbench, but the current connection is dead. How do I reconnect?

I don't want to open a new connection as I would have to copy my queries and tabs over.

Answer

BugHunterUK picture BugHunterUK · Feb 8, 2016

Done it.

Query Menu -> Reconnect to Server

Related questions

MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More
MySQL: How to allow remote connection to mysql

I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source. How can I do that?

Read More
Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is …

Read More