5

Cannot connect to MySQL through SSH tunnel with MySQL Workbench without compromising security

view full story
linux-howto

http://serverfault.com – I'm on Windows 7 with MySQL Workbench 5.2.44 CE trying to connect to MySQL database at a remote Ubuntu 12.04.1 server using "Standard TCP/IP over SSH" feature of MySQL Workbench with a passphrased SSH key. The error message I keep getting from Workbench is: Failed to Connect to MySQL at localhost:3306 through SSH tunnel example.com:2222 with user root Lost connection to MySQL server at 'reading initial communication packet', system error: 0 After hours of exercising the trial-and-error method, I seem to have figured out that the problem was in /etc/ssh/sshd_config, at the config line (HowTos)