I am trying to use SQLYog to connect to a MySQL database server which is located on a remote machine running Centos 5.2 using ssh tunnelling. Every time I try to connect I get “Error No. 2013. Lost connection to MySQL server during query”.
I have checked the credentials for ssh and for logging on to MySQL and these are both correct (I can log in to the remote machine over ssh, and log in to MySQL from that). I have also checked that port forwarding is allowed in the ssh configuration as suggested here: http://webyog.com/faq/22_113_en.html.
I have had this all working on a local network, but can't get it to work with the virtual private server I am using (1 and 1). Any ideas about what I should be looking for?