MySQL配置时区

209 阅读1分钟

Spring Boot连接MySQL,需在application.properties中配置。

Attention!

  • 必须在url后设置时区serverTimezone=UTC,否则会报错

使用com.alibaba.druid数据源:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.20</version>
</dependency>
#数据库连接
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.url=jdbc:mysql://localhost:3306/***?serverTimezone=UTC
spring.datasource.username=***
spring.datasource.password=***