what is PuTTY?
PuTTY is open source software that is available with source code and is developed and supported by a group of volunteers.
Please find the below steps to create tunnel from windows:
- Please open PuTTY application and enter the server hostnameor IP address.
2. Now, we need to setup the tunnel. Choose Connection -> SSH -> Tunnels. In Source port box, enter 3306 and in Destination 127.0.0.1:3306. Click Add. If your mysql server uses another port, please enter as such.
3. The forwarded port is listed now. Click Open. It will start SSH connection to remote server. You will need to enter username and password. Once you connect successfully, do not close the PuTTY window because it has the SSH Tunnel to the remote server.
4. Open MySQL Workbench and enter the hostname as 127.0.0.1 and port 3306
5. Enter your password for MySql on the remote machine.
6. Finally you will receive the confirmation message as given below.
No comments:
Post a Comment