How to set SSH properties in navicat

Secure SHell (SSH) is a program for logging into other computers over the network, running commands on the remote server, and moving files from one machine to another. In an unsecured network, providing strong authentication and secure encrypted communication between two hosts is called SSH Port Forwarding (Tunneling). Typically, an encrypted version of Telnet is used.

Telnet uses plain text to transmit usernames and passwords, and anyone can monitor and steal passwords or other information. This situation is susceptible to hijacking, and once authenticated, a malicious user can take over. The purpose of SSH is to prevent this vulnerability and allow shell access to the remote server without compromising security. It should be noted that SSH settings can only be applied to MySQL, Oracle, PostgreSQL, SQL Server and MariaDB.

Make sure the parameter "AllowTcpForwardin" on the Linux server is set to "yes", otherwise, SSH port forwarding will be disabled. Search path: /etc/ssh/sshd_config. By default, SSH port forwarding should be enabled, please double check the setting of this value.

Warm reminder: Even if the server supports SSH channel, but port forwarding is disabled, Navicat cannot connect through SSH port 22.

Hostname or IP address: The host of the SSH server.

Port: The port of the SSH server, which is 22 by default.

Username: The user of the SSH server machine, not a database server user.

Verification method: It is divided into password and public key, and the public key includes private key and passphrase.

Password: Provide the SSH server user password.

Private key: Used together with the public key, the private key is only readable by the user.

Passphrase: The passphrase is exactly the same as the password and applies to the generated key instead of the account.

Note: The General tab Navicat hostname is provided by the database hosting company and should be set relative to the SSH server.

The above is the detailed content of How to set SSH properties in navicat. For more information, please follow other related articles on the PHP Chinese website!