how to monitor who change the data inside the database mysql
<p>What I want to achieve is to determine who change the data inside my database table, What I am doing right now is that I created a MySQL trigger that will record the current USER()  logged in, but I found a dead end with this since I have multiple users that I want to keep track to, and mysql trigger only allows 1 definer per trigger and I can only have 1 trigger per event which is cannot satisfy my current requirement where I need to keep track of all the users, meaning I need to know which one of them changed anything inside the database. Is there anyway for me to achieve this using mysql trigger? or another by pass option?</p>