Java-改用mysql8报错，com.mysql.jdbc.Driver 已经过时了，使用新的驱动 com.mysql.cj.jdbc.Driver

以你之姓@ 2024-04-08 11:03 65阅读 0赞

/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/bin/java -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -javaagent:/Applications/IntelliJ IDEA.app/Contents/lib/idea_rt.jar=53759:/Applications/IntelliJ IDEA.app/Contents/bin -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -Dfile.encoding=UTF-8 -classpath /Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/cat.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/charsets.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/cldrdata.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/crs-agent.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/dnsns.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/jaccess.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/legacy8ujsse.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/localedata.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/nashorn.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/openjsse.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/sunec.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/sunjce_provider.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/sunpkcs11.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/ext/zipfs.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/jce.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/jfr.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/jsse.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/management-agent.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/resources.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/jre/lib/rt.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/lib/dt.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/lib/jconsole.jar:/Library/Java/JavaVirtualMachines/zulu-8.jdk/Contents/Home/lib/tools.jar:/Users/zhou/IdeaProjects/mybatis-plus/target/classes:/Users/zhou/repository/org/springframework/boot/spring-boot-starter-web/2.5.10/spring-boot-starter-web-2.5.10.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-starter/2.5.10/spring-boot-starter-2.5.10.jar:/Users/zhou/repository/org/springframework/boot/spring-boot/2.5.10/spring-boot-2.5.10.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-starter-logging/2.5.10/spring-boot-starter-logging-2.5.10.jar:/Users/zhou/repository/ch/qos/logback/logback-classic/1.2.10/logback-classic-1.2.10.jar:/Users/zhou/repository/ch/qos/logback/logback-core/1.2.10/logback-core-1.2.10.jar:/Users/zhou/repository/org/apache/logging/log4j/log4j-to-slf4j/2.17.1/log4j-to-slf4j-2.17.1.jar:/Users/zhou/repository/org/apache/logging/log4j/log4j-api/2.17.1/log4j-api-2.17.1.jar:/Users/zhou/repository/org/slf4j/jul-to-slf4j/1.7.36/jul-to-slf4j-1.7.36.jar:/Users/zhou/repository/jakarta/annotation/jakarta.annotation-api/1.3.5/jakarta.annotation-api-1.3.5.jar:/Users/zhou/repository/org/yaml/snakeyaml/1.28/snakeyaml-1.28.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-starter-json/2.5.10/spring-boot-starter-json-2.5.10.jar:/Users/zhou/repository/com/fasterxml/jackson/core/jackson-databind/2.12.6/jackson-databind-2.12.6.jar:/Users/zhou/repository/com/fasterxml/jackson/core/jackson-annotations/2.12.6/jackson-annotations-2.12.6.jar:/Users/zhou/repository/com/fasterxml/jackson/core/jackson-core/2.12.6/jackson-core-2.12.6.jar:/Users/zhou/repository/com/fasterxml/jackson/datatype/jackson-datatype-jdk8/2.12.6/jackson-datatype-jdk8-2.12.6.jar:/Users/zhou/repository/com/fasterxml/jackson/datatype/jackson-datatype-jsr310/2.12.6/jackson-datatype-jsr310-2.12.6.jar:/Users/zhou/repository/com/fasterxml/jackson/module/jackson-module-parameter-names/2.12.6/jackson-module-parameter-names-2.12.6.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-starter-tomcat/2.5.10/spring-boot-starter-tomcat-2.5.10.jar:/Users/zhou/repository/org/apache/tomcat/embed/tomcat-embed-core/9.0.58/tomcat-embed-core-9.0.58.jar:/Users/zhou/repository/org/apache/tomcat/embed/tomcat-embed-el/9.0.58/tomcat-embed-el-9.0.58.jar:/Users/zhou/repository/org/apache/tomcat/embed/tomcat-embed-websocket/9.0.58/tomcat-embed-websocket-9.0.58.jar:/Users/zhou/repository/org/springframework/spring-web/5.3.16/spring-web-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-beans/5.3.16/spring-beans-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-webmvc/5.3.16/spring-webmvc-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-aop/5.3.16/spring-aop-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-context/5.3.16/spring-context-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-expression/5.3.16/spring-expression-5.3.16.jar:/Users/zhou/repository/org/slf4j/slf4j-api/1.7.36/slf4j-api-1.7.36.jar:/Users/zhou/repository/org/springframework/spring-core/5.3.16/spring-core-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-jcl/5.3.16/spring-jcl-5.3.16.jar:/Users/zhou/repository/com/baomidou/mybatis-plus-boot-starter/3.0.5/mybatis-plus-boot-starter-3.0.5.jar:/Users/zhou/repository/com/baomidou/mybatis-plus/3.0.5/mybatis-plus-3.0.5.jar:/Users/zhou/repository/com/baomidou/mybatis-plus-extension/3.0.5/mybatis-plus-extension-3.0.5.jar:/Users/zhou/repository/com/baomidou/mybatis-plus-core/3.0.5/mybatis-plus-core-3.0.5.jar:/Users/zhou/repository/com/baomidou/mybatis-plus-annotation/3.0.5/mybatis-plus-annotation-3.0.5.jar:/Users/zhou/repository/com/github/jsqlparser/jsqlparser/1.2/jsqlparser-1.2.jar:/Users/zhou/repository/org/mybatis/mybatis-spring/1.3.2/mybatis-spring-1.3.2.jar:/Users/zhou/repository/org/mybatis/mybatis/3.4.6/mybatis-3.4.6.jar:/Users/zhou/repository/com/baomidou/mybatis-plus-generator/3.0.5/mybatis-plus-generator-3.0.5.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-autoconfigure/2.5.10/spring-boot-autoconfigure-2.5.10.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-starter-jdbc/2.5.10/spring-boot-starter-jdbc-2.5.10.jar:/Users/zhou/repository/com/zaxxer/HikariCP/4.0.3/HikariCP-4.0.3.jar:/Users/zhou/repository/org/springframework/spring-jdbc/5.3.16/spring-jdbc-5.3.16.jar:/Users/zhou/repository/org/springframework/spring-tx/5.3.16/spring-tx-5.3.16.jar:/Users/zhou/repository/org/springframework/boot/spring-boot-configuration-processor/2.5.10/spring-boot-configuration-processor-2.5.10.jar:/Users/zhou/repository/mysql/mysql-connector-java/8.0.28/mysql-connector-java-8.0.28.jar:/Users/zhou/repository/org/projectlombok/lombok/1.18.24/lombok-1.18.24.jar com.nanjing.mybatisplus.MybatisPlusApplication
    
      .   ____          _            __ _ _
     /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
    ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
     \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
      '  |____| .__|_| |_|_| |_\__, | / / / /
     =========|_|==============|___/=/_/_/_/
     :: Spring Boot ::               (v2.5.10)
    
    2022-08-23 00:26:16.782  INFO 5443 --- [           main] c.n.mybatisplus.MybatisPlusApplication   : Starting MybatisPlusApplication using Java 1.8.0_345 on ZHOUdeiMac.lan with PID 5443 (/Users/zhou/IdeaProjects/mybatis-plus/target/classes started by zhou in /Users/zhou/IdeaProjects/mybatis-plus)
    2022-08-23 00:26:16.783  INFO 5443 --- [           main] c.n.mybatisplus.MybatisPlusApplication   : No active profile set, falling back to 1 default profile: "default"
    2022-08-23 00:26:17.223  INFO 5443 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
    2022-08-23 00:26:17.226  INFO 5443 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
    2022-08-23 00:26:17.227  INFO 5443 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.58]
    2022-08-23 00:26:17.258  INFO 5443 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
    2022-08-23 00:26:17.258  INFO 5443 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 449 ms
    Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
     _ _   |_  _ _|_. ___ _ |    _ 
    | | |\/|_)(_| | |_\  |_)||_|_\ 
         /               |         
                            3.0.5 
    2022-08-23 00:26:17.322  INFO 5443 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
    Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
    2022-08-23 00:26:17.322  WARN 5443 --- [           main] com.zaxxer.hikari.util.DriverDataSource  : Registered driver with driverClassName=com.mysql.jdbc.Driver was not found, trying direct instantiation.
    2022-08-23 00:26:17.484  INFO 5443 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
    Property 'mapperLocations' was not specified or no matching resources found
    2022-08-23 00:26:17.722  INFO 5443 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
    2022-08-23 00:26:17.728  INFO 5443 --- [           main] c.n.mybatisplus.MybatisPlusApplication   : Started MybatisPlusApplication in 1.118 seconds (JVM running for 1.372)

![cb0260db424a429cb87c1d1e93041ca7.png][]

com.mysql.jdbc.Driver 已经过时了，使用新的驱动 com.mysql.cj.jdbc.Driver

#### MySQL8.0连接配置 ####

![de9e92854d924c47b8c7ff0f6cd43d38.png][]

--------------------

**MySQL在高版本需要指明是否进行SSL连接**

jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC

![ab23dbd2a87d4d1d8b882eb3808bc025.png][]

![99dcbebfba434f50adbb87d88e8a0af6.png][]

[cb0260db424a429cb87c1d1e93041ca7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/0cabb1fefd70401e85028d7325a4a03b.png
[de9e92854d924c47b8c7ff0f6cd43d38.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/d83d806cd5d0493a8067f1b286b52682.png
[ab23dbd2a87d4d1d8b882eb3808bc025.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/5078807ecf95451c96bd22ae2ba76359.png
[99dcbebfba434f50adbb87d88e8a0af6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/08/0c8859d4ae8442c6a89303c17c75c933.png