How do I get access to the mysql logs from a RDS instance

Question

How do I get access to the MySQL logs (primarily to take a look at the insert/update/delete statements) from an Amazon RDS instance?

Answer 1

Basically, in the parameter group of your RDS instance, enable “general_log”

$ rds-modify-db-parameter-group mydbparametergroup --parameters "name=general_log,value=ON,method=immediate" 

If you did not apply the parameter group to your instance, do this:

$ rds-modify-db-instance mydbinstance  --db-parameter-group-name mydbparametergroup

Then access your mysql instance using root:

mysql> select * from mysql.general_log;

Check out this official documentation - Working with DB parameter groups