I've been facing some issues when I try to enable my DataChangeCaptureProcessor(CDC) in the RDS AuroraDb Mysql instance, I don't know what can't be, the message error is:
ProcessException: Could not connect binlog client to any of the specified hosts due to: Access denied for user 'firstname.lastname@example.org'(password YES)
Ps: The nifi container is running (on Fargate) in the same VPC of the AuroraDb Cluster, due that this should be avoid any connection issue I believe.
Mysql version: 5.7
My processor configuration:
Mysql Host: my-db.my-region.my-cluster.rds.amazonaws.com:3306
Mysql Driver Class Name: com.mysql.jdbc.Driver
Mysql Driver Location(s): /opt/nifi/nifi-current/ls-target/mysql-connector-java-8.0.23.jar