O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Setting up Secure Sockets Layer (SSL)

Secure Socket Layer (SSL) is a security protocol for establishing an encrypted link between a server and its clients, which ensures the privacy and integrity of all data transmission between the two parties.

To use SSL in Navicat, you need to have an SSL certificate; you can obtain a free solution such as OpenSSL from www.openssl.org and install it on your local server, and configure your MySQL server for SSL and set up the server-side certificate for it. Finally, you can set up the client certificate, which you will then be able to obtain from your SSL server. Complete instructions on how to install and set up OpenSSL for MySQL and the certificate for Navicat is explained in the Navicat manual.

Advanced settings ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required