Shulou(Shulou.com)06/01 Report--

This article is about how navicat sets the SSH property. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Secure SHell (SSH) is a program that logs in to other computers over the network and runs commands on remote servers to move files from one machine to another. In an insecure network, it provides strong authentication and secure encrypted communication between two hosts, which 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 condition is vulnerable to hijacking, and once authenticated, a malicious user can take over. The purpose of SSH is to prevent this vulnerability and to allow access to the shell of a remote server without compromising security. It is important to note that SSH settings can only be applied to MySQL, Oracle, PostgreSQL, SQL Server, and MariaDB.

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

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

Host name or IP address: the host of the SSH server.

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

User name: the user of the SSH server machine, not a database server user.

Authentication 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 with the public key, the private key is readable only to the user.

Passphrase: the passphrase is exactly the same as the password and applies to the generated key rather than the account.

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

Thank you for reading! The method of setting the SSH property of navicat is shared here. I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.