Communications link failure报错的可能性

Communications link failure报错的可能性

mysql版本的不同,导致数据库连接报错

以下是我解决的方式

1.Maven依赖

• mysql 5

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

• mysql 8

  <dependency>
              <groupId>mysql</groupId>
              <artifactId>mysql-connector-java</artifactId>
              <version>8.0.24</version>
          </dependency>
          <dependency>
              <groupId>commons-logging</groupId>
              <artifactId>commons-logging</artifactId>
              <version>1.2</version>
          </dependency>
  

2.配置文件

• mysql 5

  driver=com.mysql.jdbc.Driver
  url=jdbc:mysql://localhost:3306/yeyusp?useUnicode=true&characterEncoding=utf8&useSSL=false
  

• mysql 8

  需要设置时区

  driver=com.mysql.cj.jdbc.Driver
  url=jdbc:mysql://localhost:3306/yeyusp?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai