首页 > 其他 > 详细

The server time zone value 'xxxxxx' is unrecognized or represents more than one time zone

时间:2020-05-13 15:41:39      阅读:67      评论:0      收藏:0      [点我收藏+]
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.

 

使用 Oracle SQL develope 链接 MySQL出现以上错误

 

解决方案:

 

 

 

 

mysql> show variables like %time_zone%;
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone |        |
| time_zone        | SYSTEM |
+------------------+--------+
2 rows in set, 1 warning (0.00 sec)

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2020-05-13 14:09:28 |
+---------------------+
1 row in set (0.02 sec)

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2020-05-13 14:10:51 |
+---------------------+
1 row in set (0.00 sec)

mysql> set time_zone=SYSTEM;
Query OK, 0 rows affected (0.02 sec)

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2020-05-13 14:11:13 |
+---------------------+
1 row in set (0.00 sec)

mysql> set global time_zone=+8:00;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)

mysql>

 

技术分享图片

 

原文地址 :https://www.cnblogs.com/panjinzhao/p/12882093.html

The server time zone value 'xxxxxx' is unrecognized or represents more than one time zone

原文:https://www.cnblogs.com/panjinzhao/p/12882093.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!