mysql ssl 설정 및 적용

vi my.cnf

[mysqld]
ssl-ca = /home/mysql/fullchain3.pem
ssl-key = /home/mysql/privkey3.pem
ssl-cert = /home/mysql/cert3.pem

service restart mysqld or mariadb

MariaDB [(none)]> show variables like '%ssl%';
+---------------------+-----------------------------+
| Variable_name       | Value                       |
+---------------------+-----------------------------+
| have_openssl        | YES                         |
| have_ssl            | DISABLED                    |
| ssl_ca              | /home/mysql/fullchain3.pem  |
| ssl_capath          |                             |
| ssl_cert            | /home/mysql/cert3.pem       |
| ssl_cipher          |                             |
| ssl_crl             |                             |
| ssl_crlpath         |                             |
| ssl_key             | /home/mysql/privkey3.pem    |
| version_ssl_library | OpenSSL 1.1.1f  31 Mar 2020 |
+---------------------+-----------------------------+
10 rows in set (0.002 sec)

mysql \
-u root \
-p test \
-h localhost \
--ssl=TRUE \
--ssl-ca=/etc/letsencrypt/live/nikeshoes.shop/fullchain.pem \
--ssl-cert=/etc/letsencrypt/live/nikeshoes.shop/cert.pem \
--ssl-key=/etc/letsencrypt/live/nikeshoes.shop/privkey.pem