作者:招聘HR | 来源:互联网 | 2023-09-09 09:02
idea连接mysql报错Serverreturnsinvalidtimezone.GotoAdvancedtabandsetserverTimezonepropertyidea连
idea连接mysql报错Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property
idea连接mysql报错Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property
原因
时区问题,MySQL驱动默认UTC时区。
解决方案
- 修改时区
# 设置全局时区 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