MySQL SSH Tunnel


/ Published in: Bash
Save to your folder(s)

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.


Copy this code and paste it in your HTML
  1. ssh -L 3307:localhost:3306 myusername@mydomain.com

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.