MYSQL client connection over SSH Tunnel to Ubuntu hosted MySQL not working

I am attempting to setup an SSH tunnel to a remote server but I am not succeeding. The following summarizes the situation.
Time difference between server and local machine 4seconds
Local Setup
Windows 8.1
Putty 
configured with Tunnel L3307 localhost:3306
Auth: standard - no Private Key

Open in new window

MySQL client (various)
Host Address : localhost
username: user
password: ********
Port: 3307

Open in new window

PUTTY connects fine. The following command to connect locally to MySQL in SSH session is successful
mysql -h localhost -u user -p

Open in new window

When trying to connect from MySQL client on Windows machine

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

Open in new window

my.cnf
[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

Open in new window

sshd_config
X11Forwarding yes
X11DisplayOffset 10
PrintMotd no
PrintLastLog yes
TCPKeepAlive yes
AllowTcpForwarding yes

Open in new window

Putty Log
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]

Open in new window


/var/log/auth.log
Aug 22 14:12:48 myserver sshd[6814]: error: connect_to localhost port 3306: failed.

Open in new window

LVL 66
Julian HansenAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Julian HansenAuthor Commented:
I resolved the problem.

Changed the local address from localhost to the bound IP and that works.
L3307 192.168.0.50

Open in new window

Instead of
L3307 localhost:3306

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Julian HansenAuthor Commented:
I resolved the issue myself but have left the question here in case it is useful to someone else.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.