Logging to remote MySQL Server using SSH tunneling
Very often, we all need to access a remote database for debugging or any other related stuff.
The simplest thing that comes to mind is to take the dump of remote database and bring it to the local and run the application using that data.
We can avoid that, if we can connect our local mysql client to a remote machine over a SSH connection so that we can run queries on remote machine from our client machine, without dumping the database of remote machine.
To do that, we need to just need to remote machine over SSH with -L option
[java]
ssh -L 32001:127.0.0.1:3306 ubuntu@hostname.com
[/java]
This means that we redirected call on port number 32001 to port number 3306 on the remote machine and all responses from the remote machine on 3306 will be redirected to 32001 on the local machine.
All we need to do now is to open mysql client and attach it to port number 32001 on local machine, we need to do
[java]
mysql -h 127.0.0.1 -P 32001 -u’username’ -p’password’
[/java]
Here we are connecting to local machine on port number 32001, with username and password for that of the remote machine.
Thanks
Sachin Anand
sachin@intelligrape.com
@babasachinanand
this is a good way instead of directly logging into server via ssh. because you might accident your server and cause problems