Exception in thread "main" java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrec

最新推荐文章于 2022-10-19 00:22:13 发布

luckily灬

最新推荐文章于 2022-10-19 00:22:13 发布

阅读量1w

点赞数 56

CC 4.0 BY-SA版权

分类专栏： mysql数据库连接文章标签： JDBC mysql 数据库连接

本文链接：https://blog.youkuaiyun.com/weixin_38888926/article/details/89476144

mysql数据库连接专栏收录该内容

1 篇文章

订阅专栏

本文详细解析了在使用MySQL数据库时出现的时区配置错误'ServerTimezoneValue'问题，提供了解决方案，只需在数据库连接URL中添加特定参数即可避免此错误。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在编程路上遇到的问题记录下

Exception in thread "main" 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.
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127)

该错误为是系统时间错误

只需要在访问数据库的Url后面加上以下的语句即可：

?serverTimezone=GMT%2B8

例如URL为：

jdbc:mysql://localhost:port/test

改为：

jdbc:mysql://localhost:port/test?serverTimezone=GMT%2B8

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

luckily灬

关注关注

56
点赞
踩
36

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

springboot启动报错 Cause:java.sql.SQLException: The server time zone value ‘ÖÐ¹ú±ê×¼Ê±¼ä‘ is unrecognize

weixin_45577058的博客

08-27

759

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'userMapper' defined in file [D:\学习课程\S4\s4_谷粒在线教育项目\day01_进行mybatis_plus的进阶学习\code\mybatis-plus-demo\target\classes\com\liujie\mybatisplus\mapper\UserMapper.cl

Mysql解决报错java.sql.SQLException: The server time zone value ‘ÖÐ¹ú±ê×¼Ê±¼ä‘ is unrecognized解决方案

北溟南风起

09-02

599

Mysql解决报错java.sql.SQLException: The server time zone value ‘ÖÐ¹ú±ê×¼Ê±¼ä’ is unrecognized解决方案原因：系mysql系统时区相关比较靠谱的解决办法：通过mysql命令行改回北京时区（东8区）输入指令进入启动mysql net start mysql 输入用户名和密码进入mysql mysql -u root -p 输入自己的数据库密码查看现有的mysql时区 select curtime(

18 条评论您还未登录，请先登录后发表或查看评论

异常：java.sql.SQLException: The server time zone value ‘?й???????’ is unrecognized or represents more

12-14

异常错误：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. 出现

Exception in thread “main“ java.sql.SQLException: The server time zone value xxx异常

l_kw123456的博客

09-07

2973

问题描述：jdbc连接MySQL数据库时报错：Exception in thread “main” java.sql.SQLException: The server time zone value XXX异常问题分析：这是由于mysql8.0以上版本默认的时区和本地时区不一致导致的，即时间区域时差问题其默认的时区是UTC代表的是全球标准时间，但是我们使用的时间即本地时区是北京时区也就是东八区，领先UTC八个小时。问题解决：可以在连接数据库的url后面加上以下语句“?serverTimezone=G

Exception in thread “main“ java.sql.SQLException: The server time zone value

qq_44336097的博客

11-13

454

jdbc:mysql://localhost:port/test 替换为 jdbc:mysql://localhost:port/test?serverTimezone=GMT%2B8

java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized...

你好，开发者

07-04

6044

今天又遇到了这个错误，每次都要去寻找错误原因非常得浪费时间，所以决定以后遇到了问题之后都到这里来记录一下错误。 java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone. You must configure eith...

【JavaDebug（一）】Exception in thread “main“ java.sql.SQLException: The server time zone value

开发小鸽

08-20

357

本文章由公号【开发小鸽】发布！欢迎关注！！！老规矩–妹妹镇楼：一. 错误概况 package JDBC; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class test { public static void main(String[] args) throws IOExcept

解决mysql报错The server time zone value ‘ÖÐ¹ú±ê×¼Ê±¼ä‘ is unrecognized or represents.../服务器时区值无法识别

ABC的博客

10-19

5424

解决MySQL数据库服务器时区值无法识别问题

解决：InvalidConnectionAttributeException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or

aigoV的博客

05-14

2502

1、问题：搭建了一个新的项目，启动时报了个数据库有关的异常： Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zo...

java.sql.sqlexception: the server time zone value 'ÖÐ¹ú±ê&times;¼Ê±¼ä' 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.

06-28

这个错误提示意思是：服务器时区值“ÖÐ¹ú±ê&times;¼Ê±¼ä”无法识别或表示多个时区。如果您想使用时区支持，您必须配置服务器或JDBC驱动程序（通过servertimezone配置属性）以使用更具体的时区值。这通常...

Exception in thread “main“ java.sql.SQLException: The server time zone value ‘�й��׼ʱ��‘

无

10-22

1482

问题完整提示： Exception in thread "main" 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

JDBC测试错误记录Exception in thread “main“ java.sql.SQLException: The server time zone value ‘�й��׼ʱ��‘ i

Flowers_的博客

08-11

239

JDBC测试错误记录Exception in thread “main” java.sql.SQLException: The server time zone value ‘�й��׼ʱ��’ i 对于mysql版本为8.0的朋友一定记得下载相应版本的驱动包： mysql-connector-java-8.0.20 链接：https://pan.baidu.com/s/1uMe5N8XHQSsSBowDYD24Fg 提取码：fh5j （摘自https://blog.csdn.net/qq_4154422

mysql-8.0.11 jdbc连接数据库 The server time zone value ‘�й��׼ʱ��’ is unrecognized or represents more… 错误

weixin_41660378的博客

05-12

3743

Exception in thread “main” 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...

Exception in thread “main“ java.sql.SQLException: The server time zone value ‘�й��׼ʱ��‘ is unrecogn

chenandyuan的博客

11-19

250

Exception in thread “main“ java.sql.SQLException: The server time zone value……

今天好好优秀了么

07-04

1353

用java连接数据库的时候出现该错误，是系统时间错误解决办法：在URL后加上?serverTimezone=GMT%2B8 //原URL： jdbc:mysql://localhost:3306/test //现URL jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8

Exception in thread "main" java.sql.SQLException: The server time zone value '�й��׼ʱ��' is unrecogn

ITupup的博客

04-07

3224

问题：Exception in thread "main" 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 (...

Exception in thread “main“ java.sql.SQLException: The server time zone value ‘ÖÐ¹ú±ê×¼Ê±¼ä‘ is unrec

SCU-JJkinging的博客

11-16

253

在编程路上遇到的问题记录下 Exception in thread "main" 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 prop