MySQL client (various)
Windows 8.1 Putty configured with Tunnel L3307 localhost:3306 Auth: standard - no Private Key
PUTTY connects fine. The following command to connect locally to MySQL in SSH session is successful
Host Address : localhost username: user password: ******** Port: 3307
When trying to connect from MySQL client on Windows machine
mysql -h localhost -u user -p
Error: 2013 SQLYog: Lost connection to Mysql server at 'reading initial communication packet', system error 34 MySQL command line: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 Workbench: Lost connection to MySQL server at 'reading initial communication packet', system error: 0
[mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking bind-address = 192.168.0.50
X11Forwarding yes X11DisplayOffset 10 PrintMotd no PrintLastLog yes TCPKeepAlive yes AllowTcpForwarding yes
2015-08-22 14:12:44 Opening connection to localhost:3306 for forwarding from 127.0.0.1:60013 2015-08-22 14:12:44 Forwarded connection refused by server: Connect failed [Connection refused]
Aug 22 14:12:48 myserver sshd: error: connect_to localhost port 3306: failed.
From novice to tech pro — start learning today.