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.

1. Click or choose File -> New Connection to set up the Connection Properties.
2. Select the SSH tab and enable Use SSH Tunnel.
3. 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 database server.)
   
   Authentication Method
   Choose between Password Authentication and Public Key Authentication
   
   Password
   It is a Linux user password.
   
   

   

4. Navicat Report Viewer host name at the General Settings page should be set relatively to the SSH server in this case. For example: host_of_databaseServer shown below is the host address, which provided by your hosting company, of your remote database server.
   
   Connection Name
   A friendly name to best describe your connection.
   
   Connection Type
   Choose between MySQL and PostgreSQL.
   
   Host name/IP address
   A host where server is located in point of view SSH server. If SSH and server are on the same machine, it is equal to SSH Host, or may be 'localhost'.
   
   Port
   A port of server on Remote Host, by default it is 3306 for MySQL, 5432 for PostgreSQL.
   
   User name
   It is a server user name.
   
   Password
   It is a password of the server user.
   

   

See also:
Advanced Settings

Related topics:
Public Key Authentication (only for SSH2 Protocol)