tunnelling mysql over ssh
Suppose you have a database server (db.example.com) which only accepts connections from the web server (www.example.com). The web server accepts SSH connections from anywhere (so ssh user@www.example.com works). And you have 200 tables to update.
Start by opening a tunnelled SSH connection in a terminal window like so:
[shell]ssh user@www.example.comĀ -L 31123:db.example.com:3306 [/shell]
The command starts like a normal ssh connection.
- Read more about tunnelling mysql over ssh
- Log in to post comments