MySQL 8.0版本连接报错：Could not create connection to database server.

古城微笑少年丶 2021-11-19 19:52 308阅读 0赞

准备搭建一个Spring Boot 组合mybatis的项目，数据库采用的是MySQL 8.0.11按照以往的配置，使用插件mybatis-generator-maven-plugin生成代码时，一直报错Could not create connection to database server.如下：

[INFO] Scanning for projects...
    [INFO] 
    [INFO] ------------------------------------------------------------------------
    [INFO] Building songci-serv 1.0-SNAPSHOT
    [INFO] ------------------------------------------------------------------------
    [INFO] 
    [INFO] --- mybatis-generator-maven-plugin:1.3.5:generate (default-cli) @ songci-serv ---
    [INFO] Connecting to the Database
    [INFO] ------------------------------------------------------------------------
    [INFO] BUILD FAILURE
    [INFO] ------------------------------------------------------------------------
    [INFO] Total time: 1.841 s
    [INFO] Finished at: 2018-08-22T21:32:27+08:00
    [INFO] Final Memory: 13M/46M
    [INFO] ------------------------------------------------------------------------
    [ERROR] Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.5:generate (default-cli) on project songci-serv: Could not create connection to database server. -> [Help 1]
    [ERROR] 
    [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
    [ERROR] Re-run Maven using the -X switch to enable full debug logging.
    [ERROR] 
    [ERROR] For more information about the errors and possible solutions, please read the following articles:
    [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException

经排查是，MySQL8.0版本需要更换驱动为“com.mysql.cj.jdbc.Driver”，之前的“com.mysql.jdbc.Driver”已经不能在MySQL 8.0版本使用了，官方文档链接：https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-api-changes.html；

描述如下：The name of the class that implements java.sql.Driver in MySQL Connector/J has changed from com.mysql.jdbc.Driver to com.mysql.cj.jdbc.Driver. The old class name has been deprecated.

另外mysql-connector-java也推荐更新到8.0的版本（https://dev.mysql.com/downloads/connector/j/）。

综上修改以下两点：

1.更新mysql-connector-java版本：

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

2.更换驱动：

配置好以上两点，运行mybatis-generator-maven-plugin，接着报错如下：

Failed to execute goal org.mybatis.generator:mybatis-generator-maven-plugin:1.3.5:generate (default-cli) on project songci-serv: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support. -> [Help 1]
    [ERROR] 
    [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
    [ERROR] Re-run Maven using the -X switch to enable full debug logging.

报时区错误，解决方法执行命令给MySQL服务器设置时区为东八区，这个是com.mysql.cj.jdbc.Driver需要指定的：

mysql> set global time\_zone='+8:00';  
Query OK, 0 rows affected  
Navicat中命令列介面执行即可。或者在数据库连接配置中加上serverTimezone=GMT%2B8（代表东八区），如下：

connectionURL="jdbc:mysql://127.0.0.1:3306/songci?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8"

欢迎加入Java技术交流群：659270626

群内提供免费的学习指导,提供Spring源码、MyBatis、Netty、Redis,Kafka、Mysql、Zookeeper、Tomcat、Docker、Dubbo、Nginx、分布式、高并发、性能调优等架构技术架构资料以及免费的解答

不懂的问题都可以在本群提出来,之后还会有职业生涯规划以及面试指导