window 环境测试flink cdc,mysql Time zone 报错

Mysql Time zone 配置

1. 报错详情

2. 解决方案

报错详情

mysql time zone 时区配置报错：

Caused by: java.sql.SQLException: 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.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:76)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:197)
	at io.debezium.jdbc.JdbcConnection.lambda$patternBasedFactory$1(JdbcConnection.java:230)
	at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:871)
	at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:866)
	at io.debezium.jdbc.JdbcConnection.connect(JdbcConnection.java:412)
	at io.debezium.connector.mysql.MySqlJdbcContext.querySystemVariables(MySqlJdbcContext.java:328)
	... 11 more

解决方案

• 方案一在mysql的命令行设置。但是当主机重启之后就会失效。

  set global time_zone = '+8:00';　 ##修改mysql全局时区为北京时间，即我们所在的东8区
  set time_zone = '+8:00'; 　##修改当前会话时区
  flush privileges; 　 ##立即生效

• 方案二
  修改mysql的配置文件my.ini

 default-time_zone = '+8:00'

重启window下面的mysql服务。

net start mysql