526互联

springboot连接mysql出现的SSL问题

发布时间 2023-12-17 15:42:11作者: ccblblog

1、连接配置

spring:
  datasource:
    username: root
    password: root
    url: jdbc:mysql://192.168.0.1:3307/admin?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    driver-class-name: com.mysql.cj.jdbc.Driver

出现SSL连接问题
image

2、解决方案

修改连接为不使用SSL连接

spring:
  datasource:
    username: root
    password: root
    url: jdbc:mysql://192.168.0.1:3307/admin?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=false
    driver-class-name: com.mysql.cj.jdbc.Driver

完美解决
image