Unanswered: MySQL 5.6 Enterprise Creating Auditing Table using the plugin, PLEASE HELP!
Hi so I am somewhat new to MySQL and I have installed MySQL5.6 Enterprise package and installed the Auditing plugin (audit_log.so)
Unfortunately, I am having trouble creating a Audting table that shows the user, what was changed/inserted/deleted and the actions taken, the timestamp, the event, and the server. I am able to open the audit log file but I am trying to figure out out how to make it as a table. It also cant be allowed to be altered by any user.
Can I make it track multiple databases and put the audit table in the Information Schema?
If I can do all this, can I please get a step by step process list with commands (maybe even screenshots?). I am so lost when it is coming to this. Thank YOU!!