搭建springBoot链接mysql8一些问题

1、数据库使用连接ssl

spring.datasource.url=jdbc:mysql://localhost:3306/user?characterEncoding=UTF-8&useSSL=false

不添加会报如下信息

Sun Mar 31 10:33:23 CST 2019 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.
 

2、mysql时区设置

The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than

操作设置命令
show variables like '%time_zone%';

set global time_zone='+8:00'

3、java.sql.SQLException: Unknown system variable 'query_cache_size'

网上查了原因是mysql-connecter-java的版本过低，很显然是数据库驱动程序与数据库版本不对应

解决办法：

如 mybatis使用 mysql-5.1.14的驱动程序，而mybatis配置的数据源连接的是 mysql-8.0.11 ，修改 pom文件即可，如下：

<dependency>     <groupId>mysql</groupId>     <artifactId>mysql-connector-java</artifactId>     <version>8.0.11</version> </dependency>

 

根据官方的说法是 :

The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. Deprecation includes query_cache_size.

意思是query cache在MySQL5.7.20就已经过时了，而在MySQL8.0之后就已经被移除了。

我改成8.0.11就可以了。