Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 stackoverflow.com 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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.