Creating an SSH Tunnel

When connecting to MySQL sometimes the host does not allow for external connections to MySQL remotely for security reasons, but they do usually offer SSH access.

With SSH access you are able to create an SSH tunnel to your site/server and then connect to the port locally using your MySQL client of choice, mine being Sequel Ace on macOS.

Read more