关于在IDEA中配置Database操作步骤以及时区问题解决办法
1.配置Database步骤
2.报错解决 Server returns invalid timezone
若出现以下问题
Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property
1)打开dos命令,在执行mysql -uroot -p 键入密码后登录数据库
2)执行以下操作,修改全局时区 set global time_zone = ‘+8:00’;
设置时区为东八区 set time_zone = ‘+8:00’;
刷新权限使设置立即生效 flush privileges;
3) 执行操作及效果如下
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.20 sec)
mysql> show variables like '%time_zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | |
| time_zone | +08:00 |
+------------------+--------+
2 rows in set, 1 warning (0.08 sec)
5)在url后添加: ?serverTimezone=GMT%2B8
操作指令为:
jdbc:mysql://localhost:3306/nacos_config?serverTimezone=GMT%2B8