Connecting to a database server with NAVICAT_SSH

ssh settings (mysql, Oracle, PostgreSQL, and SQL Server only and Support SSH2 Communication protocol only)

Secure SHell (SSH) is a program that logs on to other computers over a network, runs commands on a remote server, and moves files from one machine to another. In an unsecured network, it provides powerful authentication and secure encryption of communications between two hosts, known as SSH Port Forwarding (tunneling). Typically, it is used as an encrypted version of Telnet.

In a telnet phase, all communications, including usernames and passwords, are transmitted in plain text, allowing anyone to listen to your stage job and steal passwords and other information, and this phase of work is susceptible to staged job hijacking, and once you authenticate, a malicious user can take over this stage job. The purpose of SSH is to prevent this vulnerability by allowing you to access the remote server's shell without compromising security.

Benefits of SSH Channel

SSH has a number of features called SSH Port Forwarding, sometimes referred to as SSH channel, it allows you to create a security phase of the job, and then through it to open the arbitrary TCP connection, the channel can be created at any time, hardly need any effort and programming, which makes it very attractive, In countless different ways, SSH Port Forwarding can be used for secure communication.

Many hosting companies that provide server hosting will block access to servers outside of the hosting company and grant access only to native (localhost) users.

multiple benefits of using SSH:

@ When the server port is blocked, connect to the server that is using the firewall.

@ automatically authenticates users without sending plaintext passwords to prevent passwords from being stolen.

@ Multiple powerful authentication methods to prevent security threats such as spoofed identities.

@ Secure and fast encryption and compression of data.

@ Secure file transfer.

To ensure that incoming connection requests are made by you,SSH is able to use a password, or public and private key pair (also known as a public key) authentication mechanism.

@ Password verification.

@ Public key authentication.

Note: Make sure that the parameters of the Linux server-- "allowtcpforwarding" setting value is "yes", otherwise, SSH port forwarding will be disabled. To find the path:/etc/ssh/sshd_config. By default,SSH port forwarding should be enabled. Please double-check the setting for this value.

* * Even if the server supports SSH channels, however, if port forwarding is disabled,Navicat will not be able to connect via SSH port 22.

Here is a method for password authentication:

Note: In "General", "hostname or IP address" to fill in localhost; "Port" fills the MySQL port of the remote MySQL server ; "username" fills the MySQL database user name of the remote MySQL server; "Password "Fill in the password for the user name of the MySQL database of the remote MySQL server.

Connecting to a database server with NAVICAT_SSH