Error: [CDC:ErrMySQLConnectionError]fail to open MySQL connection: Error 1298 (HY000): Unknown or in

Bruce-Lan

已于 2023-11-30 13:10:50 修改

阅读量520

点赞数

文章标签： mysql 数据库 java

于 2023-04-20 23:50:35 首次发布

本文链接：https://blog.youkuaiyun.com/longlongago7777/article/details/130278349

版权

tidb ticdc创建changefeed 或者mysql连接错误：

1，Error: unknown flag: --sink-uri"

命令行如：

tiup ctl:v5.1.1 cdc cli changefeed create --pd=http://172.31.32.241:2379 --sink-uri="mysql://root:123456@172.31.40.228:3306/" --changefeed-id="simple-replication-task" --sort-engine="unified"
把命令行中“cli”去掉。

2，[CDC:ErrMySQLConnectionError]Error 1298: Unknown or incorrect time zone: 'UTC'"

在下游执行（Loading timezone information at downstream MySQL）：

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p

$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p
Enter password: 
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.