Bug #108007 set skip-ssl before other ssl options cannot disable SSL

• Submitted: 28 Jul 2022 4:57
• Modified: 28 Jul 2022 6:54
• Reporter: yuanyue Zheng
• Status: Verified
• Category: MySQL Server: Connection Handling
• Severity: S3 (Non-critical)
• Version: 5.7*;8.0*, 8.0.30
• OS: Any
• CPU Architecture: Any

[28 Jul 2022 4:57] yuanyue Zheng

Description:
set skip-ssl before other ssl options cannot disable SSL

How to repeat:
my.cnf
[mysqld]
skip-ssl = on
ssl_cipher=AES128-SHA256

mysql> show variables like "%ssl%";
+---------------+----------------+
| Variable_name | Value          |
+---------------+----------------+
| have_openssl  | YES            |
| have_ssl      | YES            |
| ssl_ca        | ca.pem         |
| ssl_capath    |                |
| ssl_cert      | server.pem     |
| ssl_cipher    | AES128-SHA256  |
| ssl_crl       |                |
| ssl_crlpath   |                |
| ssl_key       | server.key     |
+---------------+----------------+
9 rows in set (0.00 sec)

[28 Jul 2022 6:54] MySQL Verification Team

Hello yuanyue Zheng,

Thank you for the report and feedback.

regards,
umesh