• 连接MySQL异常:The server time zone value '???ú±ê×??±??' is unrecognized or represents more than one time


    转自:https://blog.csdn.net/qq_40891588/article/details/85052923

    连接MySQL异常:The server time zone value ‘???ú±ê×??±??’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

    连接数据库时,出现时区异常:

    The server time zone value '???ú±ê×??±??' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
    

    两种解决方法:

    • 在数据库连接语句后添加?serverTimezone=UTC,即默认0时区,但是要注意,该语句需要跟在数据库连接语句的第一个位置,否则会报错,例如:
    jdbc.url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&user&password&useUnicode=true&characterEncoding=utf-8
    注意:这种方法会存在一个问题,在向数据库插入时间字段时,时间会比当前时间早8小时,即当前系统时间减8小时。

    • 修改Mysql的时区为东8区,执行如下命令即可:
    set global time_zone='+8:00'
  • 相关阅读:
    JAVA-jar包下载地址
    JAVA-Eclipse中web-inf和meta-inf文件夹
    【转载】JAVA-dynamic web module与tomcat
    判断二叉树是不是平衡
    二叉树的深度
    二叉搜索树的后序遍历序列
    数对之差的最大值
    字符串的组合
    求二元查找树的镜像
    字符串的排列
  • 原文地址:https://www.cnblogs.com/cai170221/p/14186557.html
Copyright © 2020-2023  润新知