连接MySQL报错The server time zone valuePublic Key Retrieval is not allowedCould 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>