MySQL RDS Cheat Sheet
1. Install the Command Line Client
sudo apt-get install mysql-client
2. Use the command-line client to connect
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
3. Troubleshooting Replication Errors
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.
4. Remote Host Blocked
If MySQL is telling you to run mysqladmin flush-hosts, this command doesn't appear to work. Intead use: