Springboot项目连接阿里云服务器MySql数据库
1、首先springboot中要引用依赖:
<!-- Mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
2、修改application.properties
spring:
datasource:
## 本地mysql
# username: root
# password: 你的密码
# url: jdbc:mysql://localhost:3306/data3311?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=false&rewriteBatchedStatements=true
# driver-class-name: com.mysql.jdbc.Driver
## 服务器mysql
url: jdbc:mysql://公网IPxxx:3306/mybatis_plus?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
username: root