Server returns invalid timezone. Need to set 'serverTimezone' property.

idea连接mysql报错Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property

解决方案1：修改时区

设置全局时区 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)
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | EST |
| time_zone | +08:00 |
+------------------+--------+
2 rows in set (0.00 sec)

使用第一种方式要把注释去掉或者加'#'

解决方案二：在连接数据库的url后面添加 ?serverTimezone=GMT%2B8