Navicat for Mysql无法连接问题

问题:
client does not support authentication protocol requested by server, consider upgrading mysql client.

解决:
1.进入mysql service工具的bin目录下;
2.打开cmd
2.输入 use mysql;
3.输入 alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘********’;
4.输入 flush privileges;

问题
The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized or represents more than one
解决:
1.进入mysql service工具的bin目录下;
2.打开cmd
3.输入 show variables like ‘%time_zone%’;
4.输入 set global time_zone=’+8:00’;