Spring Boot 启动报错：java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized

最新推荐文章于 2023-07-11 15:48:30 发布

原创最新推荐文章于 2023-07-11 15:48:30 发布 · 335 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了在SpringBoot项目中遇到的MySQL时区错误“Theservertimezonevalue'ÖÐ¹ú±ê×¼Ê±¼ä'isunrecognizedorrepresentsmorethanonetime”的原因及解决方案，包括更新MySQL驱动版本、指定时区和更改数据库时区。

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

错误原因：

spring Boot 项目中mysql驱动使用了旧的驱动，要求mysql新的驱动

解决办法：

1.mysql驱动更换新的驱动版本

老版本驱动：

driverClassName: com.mysql.jdbc.Driver

新版本驱动：

driverClassName: com.mysql.cj.jdbc.Driver

2使用老的版本驱动，指定时区

url: jdbc:mysql://127.0.0.1:3306/fybos_base?characterEncoding=utf-8&serverTimezone=UTC

3.更改数据库时区

提示系统时区出现错误，可以在mysql中执行命令：
set global time_zone='+8:00'

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

lxhmall

关注关注

0
点赞
踩
0

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

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

weixin_45577058的博客

08-27

788

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

634

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(

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

【SpringBoot】java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized

象在舞的技术专栏

05-15

570

SpringBoot项目中调用了MySQL数据库的数据，结果在查询数据的时候报了如下的错误： java.sql.SQLException: The server time zone value '???ú±ê×??±??' is unrecognized or represents more than one time zone. You must configure either the s...

java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä'.. 问题解决方法

12-14

375

刚刚在java中连接Mysql数据库的尝试中，程序报出了如下的错误： Exception in thread "main" ...

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

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

开发小鸽

08-20

377

本文章由公号【开发小鸽】发布！欢迎关注！！！老规矩–妹妹镇楼：一. 错误概况 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

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

无

10-22

1521

问题完整提示： 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

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

ABC的博客

10-19

5477

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

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

aigoV的博客

05-14

2539

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

解决MySQL连接时异常InvalidConnectionAttributeException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unreco

Peacock__的博客

02-22

2188

详细报错信息 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 serverTimez...

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

给你糖ya的博客

07-11

953

注：由于我在网上搜了很久，并没有我这种情况的解决方法，所以我这种解决方法可能有点投机取巧，大概率帮不上忙。如果你已经尝试过；；；等方法，还是不能解决问题，那可以看一下本文。

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

Flowers_的博客

08-11

266

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

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

chenandyuan的博客

11-19

304

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 m

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

weixin_41660378的博客

05-12

3769

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

l_kw123456的博客

09-07

3001

问题描述：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

473

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

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

ITupup的博客

04-07

3247

问题：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

Spring Boot 启动 报错：java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized

Spring Boot 启动报错：java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized