Posted By

danshields on 10/19/09


Tagged

mysql ssh


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

farondomenicgmailcom


MySQL SSH Tunnel


 / Published in: Bash
 

URL: http://www.sitepoint.com/blogs/2009/03/10/how-to-administer-a-remote-mysql-database-using-ssh-tunneling/

Where:

* 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
* mydomain.com 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 myusername@mydomain.com

Report this snippet  

You need to login to post a comment.