Unfortunately not with the standard configuration. You're best bet going forward would be to look at MySQL Enterprise Audit - https://www.mysql.com/products/enterprise/audit.html
On Tue, Oct 10, 2017 at 3:54 PM, Gone, Sajan <sg...@lb.com> wrote: > Hi, > > We have a MySQL instance which is currently running on version > `5.7.11-enterprise-commercial-advanced-log`. On this instance I am > trying to figure out the most recent timestamp at which a specific user has > established a connection to this instance (or) performed any DML operations > which might have changed the status of the database. > > Is there any way I can get such information from the > information_schema/performance_schema > tables (or) from any of the mysql logs? > > Thank You, > Sajan Gone > Database Administrator. > > ________________________________ > > Notice: This communication may contain privileged and/or confidential > information. If you are not the intended recipient, please notify the > sender by email, and immediately delete the message and any attachments > without copying or disclosing them. LB may, for any reason, intercept, > access, use, and disclose any information that is communicated by or > through, or which is stored on, its networks, applications, services, and > devices. >
