0 votes
1 view
in AWS by (19.2k points)

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?

1 Answer

0 votes
by (44.6k points)

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  

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...