Error 1045 access denied from DMS source database

Question

I got below error while try to migrate database from Mysql enterprise version 8.0.23-commercial even I grant all REPLICATION CLIENT, REPLICATION SLAVE to migration user I still got this error and also turn on binlog

[SOURCE_CAPTURE ]E: Error 1045 (Access denied for user 'migration'@'IP' (using password: YES)) connecting to MySQL server 'IP' [1020414] (mysql_endpoint_capture.c:297)

2021-09-28T17:46:20 [SOURCE_CAPTURE ]E: Errors in MySQL server binary logging configuration. Follow all prerequisites for 'MySQL as a source in DMS' from https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html or'MySQL as a target in DMS' from https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.MySQL.html [1020414] (mysql_endpoint_imp.c:778)

If migrate full load only via this endpoint it successfully this error found when full load + on going migration

Answer 1

To replicate database migration must use TCP/IP port. You should check this port and run database migration again.