Canal 启动报错Caused by: java.io.IOException: caching_sha2_password Auth failed

桃扇骨 2023-10-10 16:11 56阅读 0赞

启动Canal 后，报错信息：

2023-02-06 15:51:54.276 [destination = example , address = /127.0.0.1:3306 , EventParser] ERROR com.alibaba.otter.canal.common.alarm.LogAlarmHandler - destination:example[com.alibaba.otter.canal.parse.exception.CanalParseException: java.io.IOException: connect /127.0.0.1:3306 failure
    Caused by: java.io.IOException: connect /127.0.0.1:3306 failure
        at com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.connect(MysqlConnector.java:85)
        at com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.connect(MysqlConnection.java:89)
        at com.alibaba.otter.canal.parse.inbound.mysql.MysqlEventParser.preDump(MysqlEventParser.java:87)
        at com.alibaba.otter.canal.parse.inbound.AbstractEventParser$1.run(AbstractEventParser.java:176)
        at java.lang.Thread.run(Unknown Source)
    Caused by: java.io.IOException: caching_sha2_password Auth failed
        at com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.negotiate(MysqlConnector.java:260)
        at com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.connect(MysqlConnector.java:82)
        ... 4 more

**产生原因：**

自MySQL 8.0.3开始，身份验证插件默认使用caching\_sha2\_password

**解决办法：**

修改canal用户对应的身份验证插件为mysql\_native\_password

select host,user,plugin from mysql.user ;
    
    ALTER USER 'canal'@'%' IDENTIFIED WITH mysql_native_password BY 'password';

![950b4fca30ad4d5db63892a6647da209.png][]

[950b4fca30ad4d5db63892a6647da209.png]: https://img-blog.csdnimg.cn/img_convert/950b4fca30ad4d5db63892a6647da209.png