Server returns invalid timezone. Need to set ‘serverTimezone’ property.
终端进入数据库mysql,依次执行以下命令:
# 设置全局时区 mysql> set global time_zone = '+8:00';
Query OK, 0 rows affected (0.00 sec)
# 设置时区为东八区 mysql> set time_zone = '+8:00';
Query OK, 0 rows affected (0.00 sec)
# 刷新权限使设置立即生效 mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
执行完以上命令之后在URL中加上
?serverTimezone=GMT%2B8
,再次连接即可成功