Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failureThe last p

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

The last packet successfully received from the server was 10,310 milliseconds ago. The last packet sent successfully to the server was 10,310 milliseconds ago.

解决办法：

1 修改 pom文件 驱动版本8.0.19

<!-- Mysql Connector -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.19</version>
</dependency>

2、

数据库配置  重点 druid

dynamic:
  druid:
    initial-size: 5
    min-idle: 5
    maxActive: 60
    maxWait: 180000
    timeBetweenEvictionRunsMillis: 180000
    minEvictableIdleTimeMillis: 300000
    validationQuery: SELECT 1 FROM DUAL
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true
    maxPoolPreparedStatementPerConnectionSize: 60
    filters: stat,slf4j
    connectionProperties: druid.stat.mergeSql\=true;druid.stat.slowSqlMillis\=500000
  datasource:
      # 主库数据源
      master:
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://127.0.0.1:3306/northeast?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=GMT%2B8
        username: root
        password: root

3、 主要字段添加索引