SpringBoot关于Msql报时区错误

最新推荐文章于 2025-02-07 20:38:01 发布

进击的小猴

最新推荐文章于 2025-02-07 20:38:01 发布

阅读量3.3k

点赞数

分类专栏： MySQL SpringBoot 文章标签： Mysql报错 SpringBoot

本文链接：https://blog.youkuaiyun.com/l13568/article/details/88342175

版权

SpringBoot 同时被 2 个专栏收录

6 篇文章

订阅专栏

MySQL

1 篇文章

订阅专栏

在使用SpringBoot运行时遇到MySQL时区错误，错误信息提示服务器时间 zone 值无法识别或代表多个时区。解决方法是配置服务器或JDBC驱动（通过serverTimezone配置属性），指定更具体的时间区值以启用时间区支持。

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

SpringBoot运行报错

控制台错误信息
只简单展示错误信息:

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:129) ~[mysql-connector-java-8.0.15.jar:8.0.15]

修改后的Url:

spring:
  profiles:
    active:
    - thymeleaf
    - mybatis
  # druid
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    # 注意mysql时区默认为UTC  
    # 原来的url: jdbc:mysql://127.0.0.1:3306/xxx?useSSL=false&useUnicode=true&characterEncoding=UTF-8
    url: jdbc:mysql://127.0.0.1:3306/xxx?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    username: root
    password: 123456
    # driver-class-name: com.mysql.jdbc.Driver
    platform: mysql

3.运行完成：

2019-03-08 10:16:05.812  INFO 15660 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
2019-03-08 10:16:06.046  INFO 15660 --- [           main] d.s.w.p.DocumentationPluginsBootstrapper : Context refreshed
2019-03-08 10:16:06.055  INFO 15660 --- [           main] d.s.w.p.DocumentationPluginsBootstrapper : Found 1 custom documentation plugin(s)
2019-03-08 10:16:06.080  INFO 15660 --- [           main] s.d.s.w.s.ApiListingReferenceScanner     : Scanning for api listing references
2019-03-08 10:16:06.169  WARN 15660 --- [           main] s.d.s.w.r.p.ParameterDataTypeReader      : Trying to infer dataType org.springframework.ui.ModelMap
2019-03-08 10:16:06.212  INFO 15660 --- [           main] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: toLoginUsingGET_1
2019-03-08 10:16:06.256  INFO 15660 --- [           main] o.s.a.r.c.CachingConnectionFactory       : Attempting to connect to: [192.168.137.176:5672]
2019-03-08 10:16:06.276  INFO 15660 --- [           main] o.s.a.r.c.CachingConnectionFactory       : Created new connection: rabbitConnectionFactory#38f77cd9:0/SimpleConnection@2afdf6b7 [delegate=amqp://guest@192.168.137.176:5672/, localPort= 8329]
2019-03-08 10:16:06.340  INFO 15660 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
2019-03-08 10:16:06.343  INFO 15660 --- [           main] com.example.Miaosha1Application          : Started Miaosha1Application in 3.268 seconds (JVM running for 3.854)