last modification by which user
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?
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.
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.