Securely Remote Connect to MySQL with Navicat SSH

Navicat connects to the MySQL database through ssh, without opening the database port (3306 by default), and without creating another user that allows external network connections, which can greatly improve security. Of course, if your server is enabled with ssh service. The following uses Mac version of Navicat as an example to teach you how to connect to the database through SSH. (windows version is similar)
1. Create a new connection, select the SSH tab, and set the SSH login information, as shown below:

Teach you how to securely connect to MySQL with Navicat SSH

SSH settings
2. Return to the General Settings database login information:

Teach you how to securely connect to MySQL with Navicat SSH

Database information settings
3. After the test passes, click OK.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: