I'm trying to set up SSH tunneling on a remote web server to another MySQL server so that the database can be browsed easily with MySQL Query Browser. I'm following this page but cannot connect to the MySQL server. http://www.howtogeek.com/howto/ubuntu/access-your-mysql-server-remotely-over-ssh/
What I've done:
- logged in to the web server with Putty via SSH.
ssh -L 33060:[database]:3306 [myusername]@[webserver_address]where [...]s are altered by the actual information.
I was asked a password and typed it and got the following message. So it seems login was successful.
socket: Protocol not supported
Last login: .... 2012 from .... Copyright (c) 1980, 1983, 1986, 1988, 1990, 1991, 1993, 1994 The Regents of the University of California. All rights reserved.
Welcome to FreeBSD!
Opened MySQL Query Browser in Windows and entered
Server Host: localhost
And it says,
Could not connect to the specified instance. MySQL Error Number 2003 Can't connect to MySQL Server on 'localhost' (10061)
Sorry if this is too basic. Thanks for your information.