Secure Sockets Layer (SSL) is a protocol for transmitting private files over the Internet. In order to connect securely, you need to install the OpenSSL library and download the database source first. It should be noted that SSL settings are only applicable to PostgreSQL and MariaDB, PostgreSQL 8.4 or above.
MySQL and MariaDB connection
To set up SSL, you need to check "Use Authentication" and fill in the required information.
Client key: PEM format SSL key file used to create a secure connection.
Client certificate: PEM format SSL certificate used to create a secure connection.
CA Certificate: Fill in the path to a PEM format file of a trusted SSL certificate authority list.
Verify CA certificate name: After checking this option, the server's regular name value in the certificate sent by the server to the client will be checked.
Specified Cipher: Cipher list allowed for SSL encryption.
##Related recommendations: "Navicat for mysql graphic tutorial"
Navicat settings SSL attributes
PostgreSQL connectionThe three SSL modes are as follows: require: Only try SSL connections. verify-ca: Only attempts SSL connections and verifies that the server certificate is issued by a trusted CA. verify-full: Only attempt SSL connections, 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 Verification" 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 certificate authority path. Certificate Revocation List: The file path of the Certificate Revocation List (CRL).The above is the detailed content of How to set ssl attributes in navicat premium. For more information, please follow other related articles on the PHP Chinese website!