Sign up ×

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?

share|improve this question

migrated from Jan 27 '12 at 13:21

This question came from our site for professional and enthusiast programmers.

1 Answer 1

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.

share|improve this answer

Your Answer

