Revision: 19259
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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