springboot

springboot

错误与提示

Communications link failure

springboot 项目中使用 druid 连接 mysql 报错

Disconnected from the target VM, address: '127.0.0.1:9734', transport: 'socket'
2024-09-17 21:15:02.079 ERROR 10980 --- [reate-567413964] com.alibaba.druid.pool.DruidDataSource   : create connection SQLException, 
url: jdbc:mysql://49.234.149.119:16033/visitor?userUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai, errorCode 0, state 08S01
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

注意检查数据库连接字符串，保证要有下面的4大金刚 - 特别注意要有后面的 useSSL

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    url: jdbc:mysql://49.234.149.119:16033/visitor?userUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&useSSL=false
    username: root
    password: '!XDFserver20211001@'