I was setting up a read replica of an RDS database for a reporting project, and issued an incorrect GRANT statement when configuring a user.
My RDS read replica stopped, with an error message on the slave:
The incident LOST_EVENTS occured on the master. Message: error writing to the binary log
It seems that the recovery solution is to:
stop slave; SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; start slave;
Except that the "root" user for an RDS read replica doesn't have rights to issue the stop slave command.
Is there a way to recover without deleting & recreating the read replica?