sudo apt-get install mysql-client
The below command will connect to the rds server specified after -h
and open a MySQL client connection that you can run commands against.
mysql -h myrds.gobbledygook.us-west-1.rds.amazonaws.com -umyaccount -p mysql
Catch these quickly! If you don't, then running these commands will be pointless.
This will tell you what data is causing the replication error.
show slave status\G
This will clear the errored replication and alert you if there is more.
CALL mysql.rds_skip_repl_error;
If MySQL is telling you to run mysqladmin flush-hosts, this command doesn't appear to work. Intead use:
flush hosts;