springboot连接mysql 5.7.28

pom.xml

 <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <!--<scope>runtime</scope>-->
        </dependency>

application.properties

#数据库相关配置
spring.datasource.url = jdbc:mysql://127.0.0.1:3306/wiki?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
spring.datasource.username = wiki
spring.datasource.password = root
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver

如果是阿里云数据库URL如下配置

spring.datasource.url=jdbc:mysql://rm-uf6470s9615e13hc4no.mysql.rds.aliyuncs.com/wikidev?characterEncoding=UTF8&autoReconnect=true&serverTimezone=Asia/Shanghai&allowMultiQueries=true
spring.datasource.username=wiki
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver