MySQL 8.0.18 时区修改及客户端连接 'caching_sha2_password' cannot be loaded问题

1. java.sql.SQLException: The server time zone value ‘乱码 ...time’ is unrecognized

数据库端修改办法:

--自MySQL 8.0 GA版本开始支持将参数写入并且持久化.

使用mysql自带客户端连接mysql:

mysql> set persist time_zone='+8:00';

2.  MySQL 8.0.18 error connect to "Authentication plugin 'caching_sha2_password' cannot be loaded. The specific module can not be found"

mysql > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';