连接Mysql报错: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

最新推荐文章于 2025-03-15 20:09:19 发布

GitIDEA

最新推荐文章于 2025-03-15 20:09:19 发布

阅读量588

点赞数 10

文章标签： mysql android 数据库

本文链接：https://blog.youkuaiyun.com/m0_67353272/article/details/145688952

版权

启动报错：

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

原因:

代码错误

错误代码

  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://192.168.16.140:3306/es_goods?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
    username: root
    password: root

使用mysql5用:

com.mysql.jdbc.Driver

使用mysql8或mysql5用:

com.mysql.cj.jdbc.Driver

连接取消安全验证:

useSSL=false

为了减少错误, 将密码修改为字符串:

password: “root”

最后修改后的代码:

  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://192.168.16.140:3306/es_goods?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false
    username: root
    password: "root"