问题:
The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone....
解决方案:
show variables like '%time_zone%';
set global time_zone='+8:00';
问题:
刚安装完mysql8.0.11,连接时报错:
在navicat中报错client does not support authentication
在mysql workbench中报外部组件错误
解决方法:
mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.60 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.18 sec)