(图形界面)Dbever连接MySQL8 报错mysql8 安装The server time zone value '?й???????' is unrecognized or represents more than one time zone.

问题原因是没有设置时区,这个在Mysql8中会有

解决方式:

(图形界面)Dbever连接MySQL8 报错mysql8 安装The server time zone value '?й???????' is unrecognized or represents more than one time zone.

 

 在这个位置加上UTC时区就可以了。

IDEA添加方式

设置Advanced的allowPublicKeyRetrieval为true

 (图形界面)Dbever连接MySQL8 报错mysql8 安装The server time zone value '?й???????' is unrecognized or represents more than one time zone.

 

(图形界面)Dbever连接MySQL8 报错mysql8 安装The server time zone value '?й???????' is unrecognized or represents more than one time zone.

 

 同时安装上驱动的jar包

(图形界面)Dbever连接MySQL8 报错mysql8 安装The server time zone value '?й???????' is unrecognized or represents more than one time zone.

 

 

(图形界面)Dbever连接MySQL8 报错mysql8 安装The server time zone value '?й???????' is unrecognized or represents more than one time zone.

 

(图形界面)Dbever连接MySQL8 报错mysql8 安装The server time zone value '?й???????' is unrecognized or represents more than one time zone.

上一篇:mysql INSERT ... ON DUPLICATE KEY UPDATE语句


下一篇:mysql扩展库mysqli与OOP面向对象