Trying to Set Up SSH Tunneling To MySQL Server for MySQL Query Browser
- by Teno
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.
typed 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.
FreeBSD 7.1-RELEASE....
Welcome to FreeBSD!
Opened MySQL Query Browser in Windows and entered
Server Host: localhost
Port: 33060
UserName: myusername
PassWord: mypassword
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.