last modification by which user

[expired user #8196]'s profile image [expired user #8196] posted 10 years ago in Feature discussion Permalink
i want to know how i can check that who has changed particular field in database, what time and with which id .... is it possible to find out ip address as well?
jfalch's profile image jfalch posted 10 years ago Permalink
it is not possible; AFAIK, mysql system does not log this information, not even in the replication binlog. only possibility would be that you provide and fill username, time etc fields yourself.
it would in principle be possible to derive this information by processing the general query log. generation of the query log however, when enabled, will slow down the server considerably.

Please login to leave a reply, or register at first.