Forwarding port 3306 on Mac OS X in order to connect to a remote MySQL Database

Posted by Jonathan Mayhak on Server Fault See other posts from Server Fault or by Jonathan Mayhak
Published on 2010-04-02T21:36:50Z Indexed on 2010/04/02 21:53 UTC
Read the original article Hit count: 430

Filed under:
|
|
|

I'm on Mac OS X 10.6.2 trying to connect to ubuntu server 8.04.1 at linode.

ssh -L 127.0.0.1:3306:[[remote ip]]:3306 user@server -N

I want to set up ssh tunneling so that I can access a remote mysql server.

First of all, I'm told bind: Address already in use. This is only after I've tried the command before. How do I manually close a port forwarding session?

Second, when I change the command to be ssh -L 127.0.0.1:3310:[[remote ip]]:3306 user@server -N (I changed the local port to listen on). I'm told channel 1: open failed: connect failed: Connection refused when I try to connect to the MySQL server via MySQL workbench or sequel pro.

To connect through MySQL workbench I use the following settings:

  • host: 127.0.0.1 port: 3310 (if 3306 is in use)
  • username: mysql username
  • password: mysql password
  • database: I don't put anything in

© Server Fault or respective owner

Related posts about ssh

Related posts about macosx