Spring操作mysql数据库报错：“java.sql.SQLException: The server time zone value ‘�й���׼ʱ��‘ is unrecognized”

完整的报错是：

ERROR com.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:mysql:/xxxxx/xxxxx, errorCode 0, state 01S00
java.sql.SQLException: The server time zone value ‘�й���׼ʱ��’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the ‘serverTimezone’ configuration property) to use a more specifc time zone value if you want to utilize time zone support.
原因是使用Mysql Connector/J 6.x以上的版本时，会提示这个时区的错误，在数据源配置时，在url后拼接?serverTimezone=UTC即可，需要的话可以在通过以下方法更改指定编码格式。

useUnicode=true&characterEncoding=utf8//指定编码格式为utf8

---

此外报错的还有一个：

Loading class ’com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `'com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

这个很容易解决，将 ’com.mysql.jdbc.Driver‘替换为 'com.mysql.cj.jdbc.Driver’即可