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=***