Access to query ID or user ID

[Will Lokes]

I want to use the library for auditing data changes, but I realized I'm missing a way of identifying the DB user that caused the change. I apologize if my question is more of a MySQL binary log question than a library question. Is there a way of identifying the DB user who triggered the event or access to a query ID?

[Julien Duponchelle]

I don't think their is a way to access to this information. I don't see any fields related to that in the log. I think MySQL developers didn't provide the informations because it's not usefull for the replication of the data.

Le sam. 28 avr. 2018 à 00:45, Will Lokes <whl...@gmail.com> a écrit :

I want to use the library for auditing data changes, but I realized I'm missing a way of identifying the DB user that caused the change. I apologize if my question is more of a MySQL binary log question than a library question. Is there a way of identifying the DB user who triggered the event or access to a query ID?

--
You received this message because you are subscribed to the Google Groups "Python MySQL replication" group.
To unsubscribe from this group and stop receiving emails from it, send an email to python-mysql-repli...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Will Lokes]

That's what I was thinking, but just wanted to confirm. Thanks for the follow up!

To unsubscribe from this group and stop receiving emails from it, send an email to python-mysql-replication+unsub...@googlegroups.com.