MySQL Connection SSL Setting

MySQL Server와 Client간의 SSL을 설정 하는 방법

--
-- 01.Key 생성
--
openssl genrsa -out server-key.pem 4096
openssl req -x509 -new -nodes -days 0 -key server-key.pem -out server-cert.pem
cp server-cert.pem ca.pem
 
--
-- 02.설정
-- my.cnf
ㅡ
[mysqld]
 
ssl-ca=ca.pem
ssl-key=server-key.pem
ssl-cert=server-cert.pem
 
[mysql]
 
ssl-ca=ca.pem
ssl-key=server-key.pem
ssl-cert=server-cert.pem
 
--
-- 03. SSL 전용 유저 
--
 
grant all on test.* to `ssluser`@`%` require SSL;
 
--
-- 04. 확인
--
 
show variables like 'have_ssl'
show status like 'Ssl%'
status