java.sql.SQLException: The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC [ MySQL时区异常 ]
represents more than one time zone. You must configure either the server or JDBC
[ MySQL时区异常 ])
一、MySQL时区异常
java.sql.SQLException: The server time zone value '�й���ʱ��' is unrecognized or
represents more than one time zone. You must configure either the server or JDBC
driver (via the serverTimezone configuration property) to use a more specifc
time zone value if you want to utilize time zone support.
二、错误截图:
三、解决办法
1、修改程序
a、查看程序时区信息
- 查看url配置信息
b、修改url时区
-
url上增加:
?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf-8
2、修改数据库
a、查看MySQL时区信息
- 命令
show variables like '%time_zone%';
b、修改时区(二选一、修改全局项目才可使用)
- 仅修改当前会话的时区,停止会话失效
修改:set time_zone = '+8:00';
- 修改全局的时区配置
set global time_zone = '+8:00'; flush privileges;