Secure connection? Today we will explore an interesting task
about activating and using SSL connection in MySQL.
We will provide all necessary scripts and commands to re-play all
steps.
So assume that we have CentOS 6.5 with OpenSSL and MySQL already installed:
[root@linuxsrv3 ~]# mysql --version mysql Ver 14.14 Distrib 5.6.17, for Linux (x86_64) using EditLine wrapper [root@linuxsrv3 ~]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.6.17-log MySQL Community Server (GPL) [root@linuxsrv3 ~]# openssl version OpenSSL 1.0.1e-fips 11 Feb 2013 [root@linuxsrv3 ~]# rpm -qf `which openssl` openssl-1.0.1e-16.el6_5.7.x86_64
Our test host is a Virtual Machine with static ip address: 192.168.1.77.
The rest of contents of this article is quite straight just follow commands:
### Create Environment ### [root@linuxsrv3 ~]# …[Read more]