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

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

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

img

 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

img

这是我一开始用的

        <dependency>
            <groupId>mysqlgroupId>
            <artifactId>mysql-connector-javaartifactId>
            <version>5.1.47version>
        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以上的版本

img

Driver也改了

img

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

img

img

前端网站也报错

img

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

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