SpringBoot 连接mysql 启动时候报错:
The server time zone value ‘*** ’ is unrecognized or represents more than one time zone
此错误解决办法如下:
错误原因:时区设置错误,把数据库设置成当前系统时区,按北京时间修改
1 用root登录mysql
2 查询 time_zone 命令:show variables like ‘%time_zone%’;
3 查看是否是 system
4 如是,执行 命令:set global time_zone=’+8:00’;
设置后重新启动程序即可。
Spring连接SQL The server time zone value '*** ' is unrecognized or represents more than one time zone
最新推荐文章于 2021-08-27 08:56:21 发布