The following instruction guides you through the process of configuring a connection between Navicat and MySQL Server using SSL. To successfully establish a SSL connection, please complete Step 1: Installation of OpenSSL and MySQL and Step 2: Setting up SSL Certificate for MySQL , and set the connection properties in the corresponding boxes: Client Key, Client Certificate, CA Certificate and Specified Cipher.

1. Click or choose File -> New Connection to set up the Connection Properties.
2. Select the SSL tab and enable Use SSL.
3. To provide authentication details, enable Use Authentication and fill in the required information:
   
   Client Key, Client Certificate and CA Certificate are usually stored in your Server - /usr/local/openssl. Please copy them from the remote server to local computer.

   

   Specified Cipher (optional) is only required while ssl_type field has been set to "SPECIFIED" - [ssl_type can be found in a system database called "mysql" -> table called "user"]. Example of Specified Cipher is "EDH-RSA-DES-CBC3-SHA" which can be filled in either through the Connection Properties shown above or the "mysql" database -> "user" table -> "ssl_cipher" blob field shown below.
   
   Note: You are allowed to store your Specified Cipher into a text file in order to load into the "ssl_cipher" blob field.

   

See also:
Advanced Settings