Explore Courses Blog Tutorials Interview Questions
0 votes
in AWS by (19.1k 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.4k 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  

Related questions

Want to get 50% Hike on your Salary?

Learn how we helped 50,000+ professionals like you !

0 votes
1 answer

Browse Categories