I have a database with multiple users who have access to view/edit in phpMyAdmin.
A given row was edited by one of the users through phpMyAdmin. Is there a way for me to know which user made the edit?
NOTE: We have not touched the row since that specific edit
It may be possible to add a TRIGGER
that captures info with USER()
.
But this would mean that each user has to connect separately when using phpmyadmin, and not use some common login.