解决 Server returns invalid timezone. Go to ‘Advanced’ tab and set ‘serverTimezone’ property manually

川长思鸟来 2023-02-13 14:45 4阅读 0赞

### 报错 ###

连接Mysql8.0的时候，IDEA出现的以下错误，这是时区的问题。**Server returns invalid timezone. Go to ‘Advanced’ tab and set ‘serverTimezone’ property manually.**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyMTM2NDM5_size_16_color_FFFFFF_t_70]

### 解决方案 ###

*  **第一种，即到 Advanced 下填写时区参数，优点是：每种连接可以分时区填写，缺点是：每次都要填**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyMTM2NDM5_size_16_color_FFFFFF_t_70 1]
 *  **第二种，在数据库里修改时区，缺点是：修改之后，重启mysql服务后time\_zone会还原**  
    `show variables like '%time_zone%'; //查看时区`  
    ![在这里插入图片描述][20200529162945676.png]  
    修改时区  
    `set time_zone='+08:00'; //修改时区`  
    ![在这里插入图片描述][20200529165559347.png]
 *  **第三种，修改配置文件，window下是my.ini，linux下是my.cnf，优点：可以永久修改，因为每次启动时mysql都会去读这个配置文件，修改后重启下mysql服务就行了**  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyMTM2NDM5_size_16_color_FFFFFF_t_70 2]  
    注：这里的 **default-time\_zone=’+08:00’** 一定要写在 \[mysqld\] 下，而不是 \[mysql\] 或 \[client\]之下，否则会报**mysql: \[ERROR\] unknown variable ‘default-time\_zone=+08:00’.** 错误  
    ![在这里插入图片描述][20200529164922766.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyMTM2NDM5_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200529162016135.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyMTM2NDM5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyMTM2NDM5_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200529162405370.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyMTM2NDM5,size_16,color_FFFFFF,t_70
[20200529162945676.png]: https://img-blog.csdnimg.cn/20200529162945676.png
[20200529165559347.png]: https://img-blog.csdnimg.cn/20200529165559347.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyMTM2NDM5_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200529164529453.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzIyMTM2NDM5,size_16,color_FFFFFF,t_70
[20200529164922766.png]: https://img-blog.csdnimg.cn/20200529164922766.png

解决 Server returns invalid timezone. Go to ‘Advanced’ tab and set ‘serverTimezone’ property manually

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezon‘

相关 IDEA连接MySQL失败报错Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezon

相关 IDEA关联mysql失败 Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezon'

相关 IDEA关联Mysql失败出现Server returns invalid timezone.Go to 'Advanced' tab and set 'serverTimezon'

相关关联mysql失败_Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezon'

相关关联mysql失败 Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' mannually

相关 Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezon问题

相关解决 Server returns invalid timezone. Go to ‘Advanced’ tab and set ‘serverTimezone’ property manually

相关 idea链接数据库提示Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezone‘...

相关 Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually.