Register only to insert, update and delete mysql queries

Question

I am using a WAMP server with phpmyadmin and MySQL 5.0. I was looking for a way to only log all insert, update, and delete requests, but nothing worked.

I managed to get it to automatically generate logs by adding the line "log = C: \ wamp \ mysql \ log \ queries.log" to the my.ini mysql configuration file, but the log did not log exact queries.

I try so that whenever a request to insert, delete or update occurs, it logs the request in a file or in another table. Is this possible with procedures? What are my options?

Answer 1

This is achieved through a binary log. You enable it using the log option. You can read the contents of the binary log using this utility, mysqlbinlog.