SSH Settings

Secure SHell (SSH) is a program to log in into another computer over a network, execute commands on a remote server, and move files from one machine to another. It provides strong authentication and secure encrypted communications between two hosts, known as SSH Port Forwarding (Tunneling), over an insecure network. Typically, it is employed as an encrypted version of Telnet.

In a Telnet session, all communications, including username and password, are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated. SSH serves to prevent such vulnerabilities and allows you to access a remote server's shell without compromising security.

Note: Available only for MySQL, Oracle, PostgreSQL, SQL Server and MariaDB.

Please make sure that the parameter - "AllowTcpForwarding" in the Linux server must be set to value "yes", otherwise, the SSH port forwarding will be disabled. To look for the path: /etc/ssh/sshd_config. By default, the SSH port forwarding should be enabled. Please double check the value settings.

** Even the server support SSH tunnel, however, if the port forwarding being disabled, Navicat Report Viewer cannot connect via SSH Port 22.

Host Name/IP Address
A host where SSH server is activated.

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

User Name
A user on SSH server machine. (It is not a user of database server.)

Authentication Method

Password Provide the Linux user Password.
Public Key Private Key
It is used together with your public key. The private key should be readable only by you.

A passphrase is exactly like a password, except that it applies to the keys you are generating and not an account.

Note: Navicat Report Viewer host name at the General tab should be set relatively to the SSH server which provided by your database hosting company.