Mybatis连接mysql失败或乱码时区问题

在使用mybatis连接mysql时报错

myBatis连接MySQL报异常：com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.

在确保数据库服务正确打开并连接下

1. 确保下载的mysql版本和maven导入的版本一致

  <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.13</version>     *这里是版本号*
    </dependency>

2.如果异常中包含乱码即 以下情况

Cause By:The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone

则需要在数据库配置中的url加入时区即可解决

<property name="url" value="jdbc:mysql://localhost:3306/数据库名?serverTimezone=Asia/Shanghai"/>