MySQL之serverTimeZone问题

问题：

连接MySQL时发生错误：连接失败，error:The server time zone value 'XXX' is unrecongnized or represents more than one time zone. You must configure either the server or JDBC diriver(via the 'server Timezone' configuration property) to use a more specific time zone value if you want to utilize time zone support.

解决方案：

即上文所说的configure the server ，在mysql控制台输入命令来设置时区：

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

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2021-12-15 20:26:52 |
+---------------------+
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.01 sec)

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2021-12-15 20:27:46 |
+---------------------+
1 row in set (0.00 sec)

mysql>

即可。