笔者参考以下Springboot集成Mybaits教程,结果测试restful service时报错无法连接mysql数据库
https://www.cnblogs.com/laoyeye/articles/6840581.html
Pom配置mybait与mysql jdbc使用的dependency
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>
这里笔者mysql用的8.0版本, 参考教程里是旧版本,经过查错发现,是jdbc驱动类名与旧版有差异
application.properties
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mydb?useSSL=false&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=admin
注意
1. driver-class-name之前版本多了cj (本人遇到的坑)
2. 使用mysql 5.5.45以上版本,url中要指明useSSL
否则遇到WARN: Establishing SSL connection without server’s identity verification is not recommended.
3. 如遇到Public Key Retrieval is not allowed 错误,可以在url添加指定allowPublicKeyRetrieval=true