声明:使用 JDK8 、springboot2.0、maven3.5.4
》
》
springboot中,查询mysql数据库时候一条警告:
Mon Nov 26 19:03:45 GMT+08:00 2018 WARN:
Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
》
直接看高亮就行了,
这个问题,在druid数据库zhong遇到过,由于本人使用的mysql8
所以这种在url 中添加 ?useSSL=false 即可;
yml 文件中修改:
server:
port: 80
spring:
datasource:
# 可以推断出来className
url: jdbc:mysql://localhost:3306/leyou?useSSL=false
username: root
password: root
#mybatis
mybatis:
type-aliases-package: com.baidu.pojo
#mapper-locations: classpath:mappers/*.xml
configuration:
log-impl: org.apache.ibatis.logging.stdout.StdOutImpl #配置日志
# 使用通用mapper 无需mapper.xml
很常见的一个警告,在springboot中是警告,但是在其他工程中项目就跑不起来了