SSL协议提供服务主要:
1)认证用户服务器,确保数据发送到正确的服务器; .
2)加密数据,防止数据传输途中被窃取使用;
3)维护数据完整性,验证数据在传输过程中是否丢失;
➜ ~ mysql --ssl-mode=REQUIRED -ucpx -p 服务端没有开启 ssl
Enter password:
ERROR 2026 (HY000): SSL connection error: SSL is required but the server doesn't support it
➜ ~
[root@MSS-3tupylee8y ~]# mysql -urob -pxxx --ssl
jd@localhost [(none)]> show status like 'ssl_cipher';
+---------------+--------------------+
| Variable_name | Value |
+---------------+--------------------+
| Ssl_cipher | DHE-RSA-AES256-SHA |
+---------------+--------------------+
1 row in set (0.00 sec)
参考:https://opensource.actionsky.com/20200514-mysql/