mysql audit trial

[funbinod]

hello all!

i was wandering through web to learn about audit trial. but could not find anything from where i can understand this clearly. can anyone please tell me in details about this???

for nowm i want to know two things:

1) is this automatically done by mysql as it's feature or this is my job to maintain the complete activity???

2) if this is a mysql feature, is this available on all versions???

 

thank you in advance...

[justsomeguy]

That's a pretty vague question, but you're probably looking for this:

https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-control.html

[justsomeguy]

Note that you will not want to keep that enabled all the time.  For sites with decent traffic, that's going to eat a lot of disk space quickly.