连接MySQL报错The server time zone value/Public Key Retrieval is not allowed/Could not create connection

1.连接MySQL的时候报错The server time zone value,出现这个报错的是因为mysql的时区问题:

url: jdbc:mysql://localhost:3306/orderingsystem?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8

2.Access denied for user ‘root’@‘localhost’ (using password: YES) ，出现这个报错的原因：root用户的密码错误

3.连接数据库时出现的Public Key Retrieval is not allowed错误，在项目的JDBC连接数据库的url中，加上allowPublicKeyRetrieval=true参数，已验证可以解决该问题。

jdbc:mysql://localhost:3306/xxx?useUnicode=true&characterEncoding=utf8&rewriteBatchedStatements=true&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true

4.Could not create connection to database server.
更新mysql-connector-java版本：

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.11</version>
</dependency>