best free sql client for windows with ssh tunnel

#Best free sql client for windows with ssh tunnel how to#
#Best free sql client for windows with ssh tunnel install#

The PuTTY Security Alert warning dialog appears the first time you connect. In the Host Name (or IP address) box, under the Session tab, enter the IP address of the remote machine and click the Open button: Now, go to the local Windows machine and launch PuTTY. Go to Linux Ubuntu 18.04 and in the Terminal, type ifconfig or the IP address command and see information under inet: To connect to a remote MySQL server, you’ll need its IP address.

#Best free sql client for windows with ssh tunnel install#

Click the Install button:Īfter the successful installation, click the Finish button to close the PuTTY installer: If you plan to use PuTTY frequently, add a PuTTY shortcut to the Desktop. In the Product Features step, select the way you want the features installed. Click the Next button to continue:ĭuring the Destination Folder step, choose where the PuTTY client will be installed: For the purpose of this article, we’ll use the 64-bit PuTTY client to connect to the remote MySQL server.ĭouble click on the putty-64bit-installer.msi installer. There are many SSH clients for Windows OS. If the SSH server is not running, type and execute the sudo systemctl start ssh command. To verify that the installation was successful and the SSH service is running, type and run the sudo systemctl status ssh command: Then press Y and Enter to continue with the installation: Press the Enter key and type user password when prompted. To install Secure Shell (SSH) on Linux Ubuntu 18.4, from the Terminal type the sudo apt install openssh-server command. To see the status of MySQL, type and run the service mysql status command:Įxecute the sudo service mysql start command:

#Best free sql client for windows with ssh tunnel how to#

To see which version is installed on the machine, type and run the mysql –version command:įor detailed information on how to install and configure MySQL, please visit the How To Install MySQL on Ubuntu 18.04 page.Īfter setting up MySQL, make sure it is active and running. Next, in the Terminal, type the sudo apt-get install mysql-server command to start installing MySQL: On Linux Ubuntu 18.4, open the Terminal, type the sudo apt-get update command and press the Enter key: Installed Linux Ubuntu 18.04 on a remote machineįirst, you must install MySQL on the remote Linux machine.

Installed Windows 10 OS on a local machine This article will explain how to set up a connection from a Windows host OS using a PuTTY client to a remote MySQL server on Linux Ubuntu 18.04.