I keep losing connection

[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?

[alexa]

Could you please let us know whether you use SSH?

[jedimark]

No I don't use SSH

[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.

[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.

[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.