连接MySql报错(时区错误)——The server time zone value "" is unrecognized or represents more t...

迈不过友情╰ 2023-07-03 02:51 2阅读 0赞

在使用SpringBoot创建并启动项目时，出现的一个SqlSQLException。经查验，该问题是MySql本身的时区设置的问题导致的。完整的异常信息如下：

java.sql.SQLException: The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents morethan 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.
    
    /**
    *谷歌翻译（英文是真的垃圾，唉）：
    java.sql.SQLException：服务器时区值'ÖÐ¹ú±ê×¼Ê±¼ä'无法识别或代表多个时区。 
    如果要使用时区支持，则必须配置服务器或JDBC驱动程序（通过serverTimezone配置属性）以使用更具体的时区值。
    **/

`MySql`安装默认设置为美国时区，而北京时间比美国迟8小时。解决方法也很简单：

> 如果安装`MySql`时没有更改过默认安装路径，那么在默认的安装路径下`C:\ProgramData\MySQL\MySQL Server 8.0`找到`my.ini`文件。
> 
> ![format_png][]
> 
> 服务安装地址.png
> 
>   
> 在 `[mysqld]`下方添加： **default-time-zone='+08:00'**。 `（注意引号）`
> 
> ![format_png 1][]
> 
> 修改位置.png
> 
>

因为是在springboot项目启动时报的，与mysql连接有关的错，找到了另外一种***解决错误的方式***。

# 数据库基本配置
    spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
    spring.datasource.url=jdbc:mysql://localhost:3306/jpaLearn?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false
    spring.datasource.username=sunyu
    spring.datasource.password=sunyu

> **spring.datasource.url** 这个配置中多加了 **serverTimezone=UTC**

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy82NDkxNjQ1LTQ2ZTE5ZmNlNjk5NTM5YTgucG5nP2ltYWdlTW9ncjIvYXV0by1vcmllbnQvc3RyaXB8aW1hZ2VWaWV3Mi8yL3cvMTE2MA?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly91cGxvYWQtaW1hZ2VzLmppYW5zaHUuaW8vdXBsb2FkX2ltYWdlcy82NDkxNjQ1LWI4OTVkZTAzMzgwMDc4MWEucG5nP2ltYWdlTW9ncjIvYXV0by1vcmllbnQvc3RyaXB8aW1hZ2VWaWV3Mi8yL3cvMTEyNA?x-oss-process=image/format,png

连接MySql报错(时区错误)——The server time zone value "" is unrecognized or represents more t...

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Mysql时区差异异常-The server time zone value ‘xxx‘ 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 time zone.

相关连接MySql报错(时区错误)——The server time zone value "" is unrecognized or represents more t...

相关 The server time zone value ‘xx‘ is unrecognized or represents more than one time zone（SpringBoot错误）

相关 The server time zone value 'EDT' is unrecognized or represents more than one time zone.

相关 mybatis "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 'EDT' is unrecognized or represents

相关解决Hibernate报错The server time zone value is unrecognized or represents more than one time zone