Search code examples
mysqlphpmyadmininnodb

How can I tell which mysql user edited a table in mysql


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


Solution

  • 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.