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:
SSH settings
2. Return to the General Settings database login information:
Database information settings
3. After the test passes, click OK.
