TiCDC connection to ClickHouse error

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: ticdc连接clickhouse报错

| username: 像风一样的男子

I saw from the ClickHouse documentation that it supports the MySQL wire communication protocol. When creating a CDC task, the following error is reported:
Error: [CDC:ErrMySQLConnectionError] fail to open MySQL connection: Error 62: Code: 62. DB::Exception: Syntax error: failed at position 15 (‘“Asia/Shanghai”’): “Asia/Shanghai”. Expected one of: TRUE, FALSE, literal, NULL, number, Bool, true, false, string literal. (SYNTAX_ERROR) (version
Has anyone encountered this? How should it be handled?

| username: 像风一样的男子 | Original post link

The old version of the MySQL client cannot log in locally either. Upgrading the client to 8.0 is required to log in to ClickHouse. It is suspected that ClickHouse only supports version 8.0.


| username: dba远航 | Original post link

Syntax error: failed at position 15 (‘“Asia/Shanghai”’):

| username: 哈喽沃德 | Original post link

The error message contains the timezone parameter “Asia/Shanghai”. Ensure that the value of this parameter meets the requirements of ClickHouse.

| username: 江湖故人 | Original post link

It should be impossible to achieve 100% syntax support.