Enter a name for your new connection in the Saved Sessions field. Now scroll back up to the Session options again.Tick the Don't start a shell or command at all check box (you can skip this step if you also want access to the server's command line). Click on the SSH configuration category.Open PuTTY and enter your domain name, Home Server name, or server's IP address in the Host Name (or IP address) field.

Once you've got PuTTY installed come back here to continue the configuration for remote MySQL access. You'll need to use PuTTY to create the SSH tunnel and we have separate guide that details how to Install and setup PuTTY. Either stop it before running the tunnel above, or, change your connection command to something like: ssh -p 722 -N -L 3333:localhost:3306 will present the local end of the tunnel on your computer on port 3333 instead.

If you wanted the connection to be permanent until you next log out, then add the -f switch: ssh -p 722 -f -N -L 3306:localhost:3306 : It is important that you do not have an existing instance of MySQL listening on port 3306. That's it! You can now connect to MySQL from your local computer using 127.0.0.1 (some GUIs will connect using localhost or 127.0.0.1) as the server name on port 3306 and you will be connected securely (via the tunnel, to the server). ssh -p 722 -N -L 3306:localhost:3306 servername = substitute your own domain name, or home server nameįor example, if your Home Server was .uk and your cPanel username was krystald then the command would be ssh -p 722 -N -L 3306:localhost:3306 you hit return, you will be asked for your password (unless you have setup SSH keys on your Mac - link opens in a new window) - just enter your password and hit return - the terminal won't do anything else, so just minimise/hide the window. Open the Terminal application (using Spotlight, or go find it in Applications/Utilities).

At the client end, it could be anything you like, but in this article we will stick with 3306 also (if you are running another MySQL server locally, you might want to change the port to another number). In the case of MySQL the port at the server end would be 3306 (the standard port for MySQL). In the case of an SSH Tunnel we specify a Port at each end. An SSH connection can also serve as a secure Tunnel, through which other data can be securely exchanged. You may know that SSH allows secure terminal sessions and secure FTP (SFTP) connections, but it can also be used in other ways. SSH ( Secure SHell) is a secure method of connecting to another computer. If you are using a Mac, don't worry - you already have everything you need. If you are using Windows, then you will need to install PuTTY - read the article How to install PuTTY for SSH shell access. This is an advanced topic and assumes that you have some experience of connecting remotely to MySQL servers, TCP/IP, and SSH. This article will describe the steps required in order to connect securely to your web hosting account's MySQL server using an SSH Tunnel. Indeed, some credit card processors will not provide user accounts to websites that are hosted on servers that allow unencrypted connections on port 3306. How to connect to a MySQL database using an SSH TunnelĬonnections to MySQL servers over port 3306 are not encrypted, and so this presents a real security risk.

Mysql via ssh