Remote Server Login and Port Tunneling
You can log into your Remote Server by through SSH (Secure Shell Login) or PuTTy. PuTTy is for Windows machine to log into your Remote Server. Linux machine users no need to have PuTTy. Linux users can log into the Remote Server through Command Line SSHThe MySql ports on Web server only opened to local ports by default for security reasons. To access Mysql database on webserver from a client tool like the MySQL Query Browser, normally you’d have to open up access from your local IP address. Use port-forwarding through an SSH tunnel, so your MySQL client thinks it’s connecting to your localhost machine, but it’s really connecting to the other server through the tunnel
To create the Mysql tunnel Use the following Command
ssh -L 3306:localhost:3306 user@example.com
You could also use this technique to port-forward through one ssh server to another server
If you already have mysql running on your local machine then you can use a different local port for the port-forwarding, and just set your client tools to access MySQL on a different port
Open up the Mysql query browser and enter in the details for your remote server, using localhost as the server host, and adjust the port to whatever you used
