Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Using Putty and SSH Tunnel to connect to MySQL on remote server from SQLYog

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 744
    Comment on it

    To connect to a remote MYSQL server using SQLYog you can create SSH tunnel using putty following the steps.

    1. Connect to the remote server using putty.

    alt text.

    alt text

    1. Right Click on putty window and select the change settings option.

    alt text

    1. On settings screen click on SSH to expand and select tunnel.

    alt text alt text

    1. On the tunnel screen enter the details as in image and then click on Add and then Apply buttons.

    alt text

    1. Open SqlYog and enter the settings as in the image remember to put in correct password and username for the remote server the hostname would remain localhost only.

    alt text

    1. Click on connect and you can now access the database on the remote server using SqlYog or any of your favorite GUI clients.

    alt text

    Hope this helps.

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: