Connect to remote MySQL server from Localhost using SSH

Here's how you can connect to remote MySQL server from your localhost using SSH tunnels via local port forwarding.

You can learn more about SSH local port forwarding from the following sources;

[robertlongoria]

Thanks for this very clear description. Someday soon I will make use of it. I would like to know more about the workbench (some basic stuff) and I think you could do this for service for the community that does not know as much as you do, yet! I subscribed.

[fotiskarelas]

Thanks for this video. I am trying to do this via python SSHTunnelForwarder to connect from my raspberry pi to my server that hosts also my mysql db on 3306. The server is on different network then the client raspberry pi. How can I get this working? I guess I have to use as SSH server my NAS drive or !? Thanks

[relaxwithnetia]

Hello Dave. The best and only tutorial I found. Question, I want to be alwsys having a remote copy on anything I do on localhost xamp server, is this the solution?

[Alexanderthenotsobad]

This is excellent. I have a similar video using Putty for Windows, but you take it to the next level using Linux. I would like to link this video to my video.

[mohammedrahil]

Is it a safe practice to open db on local host ?