J.D. Hodges

Today was my first time to access a MySQL server over a SSH tunnel in Navicat. After a bit of trial and error I was finally able to achieve success 🙂

Here are the main things I learned:

#1 On the client machine running Navicat, use the same credentials that you would use if you were at the console of the remote server. In this case localhost and port 3306

Use the credentials that are local to the remote server

#2 On the SSH tab, use the remote server’s IP and SSH login credentials

Use the remote server’s IP and appropriate SSH login credentials (for security purposes you will probably want to NOT save the password)

#3 For the client machine, make sure a MySQL server instance is not running. Otherwise you will get an error similar to this:

80070007: SSH Tunnel: Socket error on connecting. WSAGetLastError return 10061($274D)

This is due to the 3306 port already being bound to the client’s MySQL server instance and so the tunnel cannot bind properly to that port. 🙁 Repeat, make sure to have port 3306 free if you will be SSH tunneling it 🙂

Hopefully these tips are helpful to you and if you want more info checkout the links below:

Access Your MySQL Server Remotely Over SSHhttp://www.howtogeek.com/howto/ubuntu/access-your-mysql-server-remotely-over-ssh/So instead, we’ll just use port-forwarding through an SSH tunnel, so your MySQL client thinks it’s connecting to your localhost machine, but it’s really connecting to the other…