Advanced Search

Return to Snippet

Revision: 19259
at October 19, 2009 22:51 by danshields
Initial Code 
ssh -L 3307:localhost:3306 [email protected]
Initial URL 
http://www.sitepoint.com/blogs/2009/03/10/how-to-administer-a-remote-mysql-database-using-ssh-tunneling/
Initial Description 
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.
Initial Title 
MySQL SSH Tunnel
Initial Tags 
mysql, ssh
Initial Language 
Bash