com.mysql报错_springboot连接mysql报错：com.mysql.jdbc.exceptions.jdbc4.CommunicationsException...

nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. ### The error may exist in file [D:\JavaProject\dataservice\target\classes\mybatis\mapper\ClassificationMapper.xml] ### The error may involve com.tjhnode.dataservice.mapper.ClassificationMapper.findAll ### The error occurred while executing a query ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

出现此错误以为是连接超时，百度答案大多是修改mysql的my.ini配置文件，设置wait_timeout时长，但是并没有解决问题。

经过分析，首先我猜想是application.yml中无法使用localhost访问，于是修改修改mysql允许ip地址访问

1.进入mysql命令行，输入select host,user from mysql.user;

发现所有host字段均为localhost；

2.设置允许被任意IP地址访问，执行 update mysql.user set host = ‘%‘ where user = ‘root‘;

然后执行  flush privileges;  刷新MySQL的系统权限相关表，客户端工具使用ip测试连接成功

重新运行项目，访问依旧报错，经过百度猜想大概是mysql驱动配置问题

3.修改application.yml中数据库连接配置，将localhost换成ip，另外，url 需要添加时区设置：&serverTimezone=UTC，

我使用的mysql版本是8.0.17，而mysql6.0以上对应的驱动要使用 com.mysql.cj.jdbc.Driver

spring:

datasource:

# 数据源基本配置

username: root

password: 123456

driver-class-name: com.mysql.cj.jdbc.Driver

url: jdbc:mysql://192.168.135.1:3306/test?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=UTC

type: com.alibaba.druid.pool.DruidDataSource

pom文件依赖

mysql

mysql-connector-java

8.0.17

原文：https://www.cnblogs.com/qinaqina/p/11826356.html