The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time zone.

最新推荐文章于 2025-09-04 13:17:00 发布

原创最新推荐文章于 2025-09-04 13:17:00 发布 · 1.4k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

Exception

当前文章被收录于：

Exception

2 篇文章 0 人学习

订阅专栏查看详情

当前文章被以下社区和专栏收录：

本文详细介绍了在使用Maven、SpringBoot和MyBatis进行项目开发时，遇到的数据库连接时区报错问题及其解决方案。通过修改application.properties配置文件中的时区设置，成功解决了因时区不匹配导致的数据库连接异常。

1.错误

在做maven +springboot + mybatis 项目连接数据库报错

Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: 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.

2.解决

修改配置文件 application.properties

### mysql数据库连接信息
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/springboot?serverTimezone=Asia/Shanghai

加上了 ?serverTimezone=Asia/Shanghai

原因时区报错

标签

#java #springboot #mysql

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

尘事如霜人如水

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
打赏
打赏
打赏举报

举报

专栏目录

CANoe基础讲解01：从零开始使用CANoe轻松搭建你的第一个CAN网络

热门推荐

程序源的博客

12-13

1万+

解决时区报错The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time zone. 描述了为什么会出现这个报错的原因。

mybase desktop 6.5.1

mybase desktop 651破解补丁，使用时从官网下载安装文件，安装完后用该文件替换同名文件即可。

MySQL报错：The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time zone

wangzhihao的博客

08-28

6396

情况 Spring Boot 连接 MySQL8.0.16 报错。错误日志信息 Spring Boot 使用 Mybatis 连接 MySQL 的详细错误日志： Caused by: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: GlobalConfigUtils setMetaData Fail !...

mysql报错：The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time zone

直到日落的博客

09-03

6615

初步学习Spring Boot的入门案例的时候，需要在springBoot的配置文件中配置mysql参数但全部配置完成之后启动spring boot的引导类，却报如下错误：java.sql.SQLException: The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time z...

The server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one time zone.

我有满天星辰的博客

04-21

2264

com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one time zone. 2020-04-21 13:49:27.504 ERROR 8432 — [eate-1...

The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time zone

比巴卜博客

07-03

2143

在闲暇之余使用Hibernate做个练习顺便回顾一下曾经的使用经历，没成想，在开发过程中遇到了大大小小的问题，但是其中一个问题对于我来说比较郁闷，就是标题所描述的这个问题，此问题找了半天，也没找到啥原因，上个刚搭建时的配置文件： <property name="hibernate.connection.driver_class">com.mysql.cj.jdbc.Driver&l...

JDBC：The server time zone value ‘�й��׼ʱ��‘ is unrecognized or represents more than one time zone.

★【World Of Moshow 郑锴】★

09-08

4373

#2020年10月9日更新#__使用Asia/Shanghai来替代具有不确定性的UTC/GMT（很多人会以为可以UTC+8或者GMT+8,想法很美好但那种用法是不存在的）。新增DBeaver / IDEA 设置jdbc属性方法。 #背景#今天项目切换到了mysql8.0.12，结果还多了一个报错，请注意…即使没有升级mysql到8.x，只升级jdbc到8.x也会导致该问题。 The server time zone value ‘�й��׼ʱ��’ is unrecognized or represen

超详解The server time zone value ‘�й��׼ʱ��‘ is unrecognized or represents more than one time zone

是谢添啊

08-22

5306

这是由于数据库和系统时区差异所造成的，MySQL8以上的驱动要求声明时区， **在jdbc连接的url后面加上serverTimezone=GMT即可解决问题**，如果需要使用gmt+8时区，需要写成GMT%2B8，否则会被解析为空。再一个解决办法就是使用低版本的MySQL jdbc驱动，5.1.49不会存在时区的问题。

ERROR: The server time zone value ‘�й��׼ʱ��‘ is unrecognized or represents more than one time zone.

qq_44154897的博客

11-17

1954

ERROR: 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 ut

[mysql] The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time zone

Java学习

11-21

1389

整合mysql报错The server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one time zone. 具体信息如下： Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: The server ...

连mysql报错The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time zone

天涯~的博客

08-06

1244

EurekaClient配置连接数据库出现如下问题： 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...

解决java连mysql出现The server time zone value ‘�й��׼ʱ��‘ is unrecognized or represents more than one问题

分享技术，传播知识!

07-24

2370

解决java连mysql出现The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one问题环境Spring配置文件出现的错误信息解决办法环境 1、SpringBoot 2.1.3 2、mysql-connector-java 8.0.20 3、mybatis 2.1.3 4、mybatisPlus 3.3.2 具体pom.xml如下： <?xml version="1.0" encoding="

解决：The server time zone value ‘�й��׼ʱ��‘ is unrecognized or represents more than one time zone.

qq_44871613的博客

12-05

4252

项目场景：问题描述：报错信息：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 v..

The server time zone value ‘�й��׼ʱ��‘ is unrecognized or represents more than one time zone.

weixin_43869132的博客

10-26

310

@[TOC](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

The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time zone.

编程语言与各种框架(Java,python)

06-18

362

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 configu...

数据库配置，启动项目报错----The Server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one

qq_38634457的博客

06-28

6155

数据库配置，启动项目报错----The Server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one time zone 数据库配置，启动项目报错----The Server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one time zone 这个错误的意思是服务器的区时不对于是先百度了怎么修改mysql的区时：首

The Server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one

Qve1995的博客

06-23

3638

pycharm 连接mysql报错，报错内容：The Server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more than one 需要登陆Navacat 修改mysql的时区改为东八区 show variables like '%time_zone%'; set global time_zone = '+8:00'; set time_zone = '+8:00'; 结果： ...

The server time zone value '�й���׼ʱ��' is unrecognized or represents more than one time zone.

1.错误

2.解决

The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time zone.