mysql 8.0.12 SSL异常排查

have_openssl=YES，即SSL是开启的，有需要的同学可以搜一下如何通过mysql配置文件关闭SSL（因为我没有关闭成功，所以在这里不展示具体步骤）。

mysql> SHOW VARIABLES LIKE ‘%ssl%‘;
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| have_openssl  | YES             |
| have_ssl      | YES             |
| ssl_ca        | ca.pem          |
| ssl_capath    |                 |
| ssl_cert      | server-cert.pem |
| ssl_cipher    |                 |
| ssl_crl       |                 |
| ssl_crlpath   |                 |
| ssl_key       | server-key.pem  |
+---------------+-----------------+

4.关闭SSL，在数据库连接url中要添加关闭SSL的参数userSSL=true

kafka.eagle.url = jdbc:mysql://localhost/ke?userSSL=true&useUnicode=true&characterEncoding=UTF8&serverTimezone=GMT

 参考文章来源：

1. MySQL5.5.45+ 5.6.26+ 5.7.6+关闭SSL验证：https://blog.csdn.net/boonya/article/details/102565062?depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-10&utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-10

2.mysql 8.0.18 调用出错解决办法：https://blog.csdn.net/qq_40604437/article/details/103715864?depth_1-utm_source=distribute.pc_relevant.none-task-blog-OPENSEARCH-3&utm_source=distribute.pc_relevant.none-task-blog-OPENSEARCH-3

mysql 8.0.12 SSL异常排查

标签：原因   ati   pat   配置   utf8   exist   connect   img   Opens