3

I am using MySQL database. Suppose a database "X". It is used by multiple users. I want to find those users who performed any transaction of data into this database. Is it possible?

Can I find it from MySQL binary log? How?

1 Answer 1

3

Yes you can find what you are looking for in mysql log files. Binary Log keeps track of the transactions that describe database changes such as table creation operations or changes to table data.

Query Log keeps track of all operations including Select and Show statements.

Both log files describe the action with the user who performed it.

This link is a tutorial for how to read binary log file.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.