HikariPool-1 - Failed to execute isValid() for connection

Question

HikariPool-1 - Failed to execute isValid() for connection, configure connection test query. (com.mysql.jdbc.Connection.isValid(I)Z)
这要怎么解决啊

后端运行没有错误，但一打开前端后端就报错，好像是连接池的问题

 ERROR 21116 --- [nio-8080-exec-5] com.zaxxer.hikari.pool.PoolBase          : HikariPool-1 - Failed to execute isValid() for connection, configure connection test query. (com.mysql.jdbc.Connection.isValid(I)Z)
2022-12-16 15:57:52.968 ERROR 21116 --- [nio-8080-exec-5] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Handler dispatch failed; nested exception is java.lang.AbstractMethodError: com.mysql.jdbc.Connection.isValid(I)Z] with root cause

这是我一开始用的

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>

spring:
   datasource:
      username: root
      password: 123456
      url: jdbc:mysql://localhost:3306/nocv?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
      driver-class-name: com.mysql.jdbc.Driver

查了一下说是mysql版本太低，于是我换成8.0.12/22

但更高的版本报错更多
用了8以上的版本

Driver也改了

报错
ERROR 22516 --- [nio-8080-exec-5] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.

前端网站也报错

于是上网查了一下又说我mysql版本太高

Answer 1

url: jdbc:mysql://127.0.0.1:3306/nocv?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT&useSSL=false