Idea mysql 时区错误

最新推荐文章于 2025-04-30 13:41:02 发布

大欺诈师

最新推荐文章于 2025-04-30 13:41:02 发布

阅读量215

点赞数

文章标签： intellij idea mysql

本文链接：https://blog.youkuaiyun.com/weixin_46454824/article/details/108517564

版权

org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: 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.
### The error may exist in com/jhj/mapper/UserMapper.xml
### The error may involve com.jhj.mapper.UserMapper.getUserList
### The error occurred while executing a query
### Cause: 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.

首先从cmd命令行中登录mysql，修改全局时区配置 set global time_zone=’+8:00’;

然后在idea的mysql设置中，在这里插入图片描述
选择自己的版本号，最后在test Connection；