Page 1 of 1
I keep losing connection
Posted: Wed 19 Feb 2014 16:31
by jedimark
I have several connections to my server database. When I try to connect to tables within databases I keep losing my connection. I hoped that the revision to 6.1 would solve that but I still get the same issue. Anyone know how to fix this?
Re: I keep losing connection
Posted: Wed 19 Feb 2014 17:30
by alexa
Could you please let us know whether you use SSH?
Re: I keep losing connection
Posted: Wed 19 Feb 2014 17:46
by jedimark
No I don't use SSH
Re: I keep losing connection
Posted: Wed 19 Feb 2014 17:52
by alexa
On the 'Advanced' tab of the Connection Properties dialog box for the connection please try to select the 'Keep connection alive' option and set the 'Ping timeout' field to the value less than the value of the 'wait_timeout' variable but greater than 0.
Re: I keep losing connection
Posted: Wed 19 Feb 2014 18:12
by jedimark
Ok, I don't see a variable "wait timeout". The only other timeouts I see are connection timeout and Execute timeout.
I am also having trouble logging on due to server not responding within 30 seconds.
Re: I keep losing connection
Posted: Thu 20 Feb 2014 10:41
by alexa
Ok, I don't see a variable "wait timeout". The only other timeouts I see are connection timeout and Execute timeout.
You can find the 'wait_timeout' variable in the 'Server Variables' window that can be invoked by selecting 'Database -> Server Variables' from the main menu.
I am also having trouble logging on due to server not responding within 30 seconds.
You can try increasing the value in the 'Connection timeout' field on the 'Advanced' tab of the 'Database Connection Properties' dialog box. Note, zero means to wait infinitively.
Also, please check whether the MySQL server is accessible from your computer.