Setting Navicat MySQL to connect to mysql via SSH tunnel
I have Navicat MySQL software and it supports connect mysql database via SSH tunnel. Here is my setting in Navicat:
However, i still cannot connect to my Linode's mysql. I keep getting this error when i Test Connection:
FYI, connecting via SSH in terminal is not a problem. Its ok. I already secure my server using this guide:
http://library.linode.com/securing-your-server
Does securing the server using that guide cause the Navicat software cannot work?
3 Replies
The contents of the "General" tab on the "New Connection" dialog box should look something like this:
Hostname/IP address: localhost
Port: 3306
Username: your MySQL username
Password: your MySQL password