Navicat MySQL Migration Toolkit for Windows

Using this mode, SSH is almost identical to the program telnet. When you make a connection, you are asked for your password. You type it in and you are either logged in or denied. Your password is first encrypted and then sent over the network and then decrypted at the remote host. This is the mode that most users will be encouraged to use, as it requires no additional setup or configuration.

The following instruction guides you through the process of configuring a SSH connection using Password Authentication. To successfully establish a SSH connection, set the SSH connection properties in the corresponding boxes: Host name/IP address, Port number, User name, Authentication Method and Password.

Click or choose File -> New Connection to set up the Connection Properties.
Select the SSH tab and enable Use SSH Tunnel.
Fill in the required information:

Host name/IP address
A host where SSH server is activated.

Port
A port where SSH server is activated, by default it is 22.

User name
A user on Linux machine. (It is a Linux user. It is not a user of MySQL Server.)

Authentication Method
Choose between Password Authentication and Public Key Authentication

Password
It is a Linux user password.
Navicat MySQL host name at the General Settings page should be set relatively to the SSH server in this case. For example: host_of_mysqldatabase shown below is the host address, which provided by your hosting company, of your remote MySQL database.

Connection Name
A friendly name to best describe your connection.

Host name/IP address
A host where MySQL Server is located in point of view SSH server. If SSH and MySQL Server are on the same machine, it is equal to SSH Host, or may be 'localhost'.

Port
A port of MySQL Server on Remote Host, by default it is 3306.

User name
It is a MySQL Server user name.

Password
It is a password of the MySQL user.