flink cdc监听mysql binlog 二进制文件实现数据同步

上官小西

已于 2022-07-27 15:25:46 修改

阅读量1.7k

点赞数

分类专栏： flinkcdc 文章标签： mysql flink

于 2022-07-27 14:31:15 首次发布

本文链接：https://blog.youkuaiyun.com/jinlinxie/article/details/126013682

版权

在使用Flink CDC从MySQL 8.0读取binlog时遇到认证错误。错误提示为'Client does not support authentication protocol requested by server'。原因是MySQL 8.0后的默认加密规则为caching_sha2_password，而Flink CDC不支持。解决方法是通过执行SQL命令将用户认证规则改为mysql_native_password：alter user 'root'@'localhost' identified with mysql_native_password by 'XXXXXX'; 并刷新权限。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

flinkcdc在读取本地的mysqlbinlog时报如下错误：

2022-07-27 14:11:35,409 WARN [org.apache.flink.runtime.webmonitor.WebMonitorUtils] - Log file environment variable 'log.file' is not set.
2022-07-27 14:11:35,409 WARN [org.apache.flink.runtime.webmonitor.WebMonitorUtils] - JobManager log files are unavailable in the web dashboard. Log file location not found in environment variable 'log.file' or configuration key 'web.log.path'.
2022-07-27 14:11:38,813 ERROR [com.alibaba.ververica.cdc.debezium.DebeziumSourceFunction] - Reporting error:
org.apache.kafka.connect.errors.ConnectException: Failed to authenticate to the MySQL database at 127.0.0.1:3306 with user 'root'
   at io.debezium.connector.mysql.BinlogReader.doStart(BinlogReader.java:441)
   at io.debezium.connector.mysql.AbstractReader.start(AbstractReader.java:116)
   at io.debezium.connector.mysql.ChainedReader.startNextReader(ChainedReader.java:206)
   a

最低0.47元/天解锁文章