I have been struggling with this issue for over a year now, and it’s really giving me a headache.
I often experience I am unable to connect to the MySQL server through SequelPRO. If I ssh into the server, I can use mysql fine, see processes, etc. My web app works fine too.
When I try to SSH into my MySQL database through Sequel PRO, this message appears instantly:
Unable to connect to host 127.0.0.1, or the request timed out. Be sure that the address is correct and that you have the necessary privileges, or try increasing the connection timeout (currently 10 seconds). MySQL said: Lost connection to MySQL server at 'reading initial communication packet', system error: 0
ONLY solution is to reboot the server. Sometimes I’d reboot the server, and it still won’t work. After a few reboots it works. But usually it works every time.
The way I connect:
MySQL Host: 127.0.0.1 Username: something Password: something Port: 3306 SSH Host: server-ip SSH User: something SSH Key: path to my id_rsa SSG Port: default/not-set
My Sequel Pro version: v1.1 build 4499 My OSX: OS X El Capitan v 10.11
Server: Ubuntu 14.04.3 LTS (GNU/Linux 3.13.0-71-generic x86_64)
MySQL: Ver 14.14 Distrib 5.7.10, for Linux (x86_64) using EditLine wrapper