Mysql：The server time zone value 'PDT' is unrecognized

秒速五厘米 2022-02-05 11:36 207阅读 0赞

> java.sql.SQLException: The server time zone value ‘PDT’ 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.  
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1570) ~\[druid-1.1.13.jar:1.1.13\]  
> at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1636) ~\[druid-1.1.13.jar:1.1.13\]  
> at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2550) ~\[druid-1.1.13.jar:1.1.13\]  
> Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value ‘PDT’ 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.  
> at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~\[na:na\]  
> at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~\[na:na\]  
> at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.\_\_newInstance(DelegatingConstructorAccessorImpl.java:45) ~\[na:na\]  
> at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45009) ~\[na:na\]  
> at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45012) ~\[na:na\]  
> at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~\[na:na\]  
> at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:85) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.util.TimeUtil.getCanonicalTimezone(TimeUtil.java:132) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.protocol.a.NativeProtocol.configureTimezone(NativeProtocol.java:2241) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.protocol.a.NativeProtocol.initServerSession(NativeProtocol.java:2265) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:1319) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:966) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825) ~\[mysql-connector-java-8.0.15.jar:8.0.15\]  
> … 6 common frames omitted  
> Process finished with exit code 130 (interrupted by signal 2: SIGINT)

## 问题背景 ##

最近家里的黑苹果终于有时间搞定，mac下idea+maven+git+jdk+mysql，无奈mysql装完挺折腾，需要重置密码，需要重置时区，如果不重置时区，默认PDT不知道是什么外星区，应该是0时区，比东八区少了八个小时，会有问题。

## 解决方案 ##

需要修改mysql的系统时区。

使用mysql连接工具或者命令好工具都可以。mac黑苹果下用终端进入mysql。

#进入mysql程序目录
    cd /usr/local/mysql/bin/
    #进入mysql，一般需要密码
    mysql -uroot -p
    #输入密码，一般mac装后在右边通知会有（其他系统绕过，正常是知道root密码的）
    #重置密码为root（非必须）
    SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root'); #查询当前时区 select now(); #控制台输出 'now()' | '2019-05-05 02:42:19' #设置时区更改为东八区 set global time_zone = '+8:00';
    #刷新配置
    flush privileges;