I'm trying to establish a remote MySQL connection through SSH in
Sequel Pro, but the connection fails with the message: "MySQL said:
Lost connection to MySQL server at 'reading initial communication
packet', system error: 0"
The FAQ suggests I edit the MySQL config file: /etc/my.conf but I
assume it's referring to the remote version to which I don't have
access.
Interestingly, I can establish a remote MySQL connection through SSH
in Terminal using the following comands:
ssh -L13306:
127.0.0.1:3306 user@hostname
then
mysql -h database -u mysql_user -p
I'm also able to establish a standard remote MySQL connection in
Sequel Pro.
I'm sure I'm entering the wrong parameters in Sequel Pro, but am not
sure which are the correct ones. Any help would be gratefully
appreciated.
Regards.