How to resolve the duplicate primary key error during replication (without skipping it)?

Question

MySQL

I'm moving to Amazon RDS MySQL. I set up master and slave according to their guide, made the dump necessary for replication, imported it to the slave, and at the start of replication I caught a duplicate key error.

Last_SQL_Errno: 1062
               Last_SQL_Error: Error 'Duplicate entry '3468603' for key 'users.PRIMARY'' on query. Default database: '~somedbname~'. Query: 'INSERT INTO users
        SET ~some insert data~'

At the moment, the master and slave data are slightly different in the key '3468603'.

UPD! Most likely due to the large version difference between MySQL 5.5.53 master -> 8.0.21 slave can you confirm this in the comments?

Answer 1

That is, you have a local master, and RDS - slave?
Perhaps you started replicating from the wrong position?