jdbc连接数据库：The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time

阳光穿透心脏的1/2处 2022-03-20 09:38 420阅读 0赞

# Mysql连接数据库错误： #

*  **错误一**

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

*  **错误二**

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

*  **这两个都表示系统时区的错误，修正时区值就可以了。**
 *  **这是在使用MySQL 8.0以上版本（MySQL连接驱动和版本都是8.0以上）的时候出现的问题错误**
 *  **CST 时区**  
    名为 CST 的时区是一个很混乱的时区，有四种含义：
    
     *  美国中部时间 Central Standard Time (USA) UTC-06:00
     *  澳大利亚中部时间 Central Standard Time (Australia) UTC+09:30
     *  中国标准时 China Standard Time UTC+08:00
     *  古巴标准时 Cuba Standard Time UTC-04:00  
        我们是中国标准时区（东八区）
 *  **第一种解决方案，修改数据库时区**
    
    用root账号登录mysql，输入

show variables like '%time_zone%';

![在这里插入图片描述][20190212105813483.jpg]  
SYSTEM为SQL默认美国时间，而我们中国要比他们迟8小时，因此，采用+8:00格式  
输入：

set global time_zone='+8:00';

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2gyNzM5Nzk1ODY_size_16_color_FFFFFF_t_70]

*  **第二种解决方案，修改jdbc连接**  
    在jdbc连接后面加

?serverTimezone=GMT%2B8

![在这里插入图片描述][20190212110106905.jpg]

[20190212105813483.jpg]: /images/20220320/0cc652ed99bc4659a334118b99d2774f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2gyNzM5Nzk1ODY_size_16_color_FFFFFF_t_70]: /images/20220320/3000728cfbbb431792d4813a7395fa90.png
[20190212110106905.jpg]: /images/20220320/7b93f10409f546de9d6956a8185c518b.png

jdbc连接数据库：The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time

发表评论取消回复

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

相关阅读

相关 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.

相关 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.

相关 The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone

相关 jdbc连接数据库：The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time

相关 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.

相关 The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone. You

相关 The server time zone value 'ÖÐ¹ú±ê×¼Ê±¼ä' is unrecognized or represents more than one time zone. You