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

This article mainly introduces the method of setting ssl property in navicat premium, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Secure Sockets Layer (SSL) is a protocol for transferring private files over the Internet. In order to connect securely, you need to install the OpenSSL library and download the database source. It is important to note that the SSL setting only applies to, PostgreSQL, and MariaDB,PostgreSQL 8.4 or above.

MySQL and MariaDB connection

To set up SSL, you need to check "use validation" and fill in the required information.

Client key: a SSL key file in PEM format used to create a secure connection.

Client certificate: a SSL certificate in PEM format used to create a secure connection.

CA certificate: the path to the PEM format file that fills in a list of trusted SSL certification authorities.

Verify the CA certificate name: when checked, the server's general name value will be checked in the certificate sent by the server to the client.

Specified Cipher: list of Cipher allowed for SSL encryption.

Navicat sets the SSL property

PostgreSQL connection

The three SSL modes are as follows:

Require: only try the SSL connection.

Verify-ca: only try the SSL connection and verify that the server certificate is issued by a trusted CA.

Verify-full: only try the SSL connection to verify that the server certificate is issued by a trusted CA and that the server hostname meets the certificate requirements.

To set up SSL, you need to check "use validation" and fill in the required information.

Client key: the path to the client key.

Client certificate: the path to the client certificate.

CA certificate: trusted certification authority path.

Certificate revocation list: the file path of the certificate revocation list (CRL).

Thank you for reading this article carefully. I hope it is helpful for everyone to share the methods and contents of setting ssl properties in navicat premium. At the same time, I also hope that you can support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

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.