This section will show you how to create an SSH tunnel to MySQL on Mac OS X or Linux. Your connection to the remote MySQL server will be encrypted through SSH, allowing you to access your databases without running MySQL on a public IP.Ĭreate an SSH Tunnel on Mac OS X or Linux If you receive this warning again for the same Linode after the key has already been cached, you should not trust the connection and investigate matters further.ĭirect your local MySQL client to localhost:3306. Once you click Yes, you won’t receive further warnings unless the key presented to PuTTY changes for some reason typically, this should only happen if you reinstall the remote server’s operating system. To get your Linode’s fingerprint, log in to your Linode via the Lish console (see the Console tab in the Linode Manager) and executing the following command: ssh-keygen -l -f /etc/ssh/ssh_host_rsa_key.pub To verify the server, compare the key fingerprint shown in the PuTTY warning - the string of numbers and letters starting with ssh-rsa in the image above - with your Linode’s public key fingerprint. It is unlikely, but possible, that someone could be eavesdropping on your connection and posing as your Linode. This warning appears because PuTTY wants you to verify that the server you’re logging in to is who it says it is. Verify that this server is the one to which you want to connect, then click Yes: If you haven’t logged in to this system with PuTTY before, you will receive a warning similar to the following. In the left-hand menu, go to Connection -> SSH -> Tunnels. You will see the following window:Įnter the hostname or IP address of your Linode in the Host Name (or IP address) field. Setting Up the Tunnelįirst, you need to establish a basic connection to your Linode:ĭouble-click the PuTTY file to begin - no need to install. This section will show you how to create an SSH tunnel to MySQL on Windows, using the PuTTY tool. How to Access MySQL Remotely by Creating an SSH Tunnel with PuTTY MySQL is configured to listen on localhost (127.0.0.1).Although this guide refers to MySQL, it applies equally to MariaDB as well. MariaDB is a fork of MySQL and considered aĭrop-in replacement.
0 kommentar(er)
