Posted By

danshields on 10/19/09


mysql ssh

Versions (?)

Who likes this?

1 person have marked this snippet as a favorite


MySQL SSH Tunnel

 / Published in: Bash



* 3307 is the local port used to connect to the remote database. You can use 3306, however, this could conflict with your PC’s MySQL installation.
* localhost and 3306 is the MySQL address from the remote server (most people will not need to change this)
* myusername is your SSH user name
* is the remote server’s domain or IP address.

The connection details are:

* ‘localhost’ for the MySQL host address (your end of the tunnel)
* ‘3307′ for the local port to the remote database (specified in the Plink command)
* the remote database name, and
* the remote username and password, i.e. a MySQL account with permissions to access and configure the database.
  1. ssh -L 3307:localhost:3306

Report this snippet  

You need to login to post a comment.