DevHeads.net

Last established connection timestamp by a specific user

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.

Comments

Re: Last established connection timestamp by a specific user

By Singer X.J. Wang at 10/10/2017 - 16:34

Unfortunately not with the standard configuration.

You're best bet going forward would be to look at
MySQL Enterprise Audit -
<a href="https://www.mysql.com/products/enterprise/audit.html" title="https://www.mysql.com/products/enterprise/audit.html">https://www.mysql.com/products/enterprise/audit.html</a>