CODEWITHSUNDEEP
javaphpmysqlsql
gustavomanolo
gustavomanolo

Reputation: 787

How can a i detect a mysql changes?

i'm looking for a way to detect when an sql statement is fired, which statement was it and which database was modified. I'm looking for a way to catch this data everytime an sql statement is executed on a mysql server (Linux server/Ubuntu).

Thanks.

Upvotes: 0

Views: 186

Answers (1)

Alain Collins
Alain Collins

Reputation: 16362

How about with triggers? I've built complex auditing systems with them before, and they're just great.

Upvotes: 3

Related Questions