We have a MySQL database on an IBM i (as/400) that has many people with admin access. We would like to audit who is making changes, and when they are made. On SQL Server we would use DDL Triggers, but those don't exist on MySQL. There is a counter proposal to do this via CREATE EVENT, but that is also unimplemented.
What options do I have to monitor DDL? Most people are using MySQL admin. I'm using MySQL Workbench, and inside the network, and inside the network all parties have direct access to the MySQL database because Microsoft Access accesses it via linked tables.
asked Oct 7, 2015 at 18:03
1 Answer 1
If you have a license for enterprise edition, upgrade to 5.5 or 5.7 and use the audit log plugin.
Justin Dearing
2,7276 gold badges36 silver badges52 bronze badges
answered Oct 23, 2015 at 1:48
-
Can you give some more meat to your answer? As written it feels more like a comment than an answer. It might be helpful to expand on "audit log plugin."Erik– Erik2015年10月23日 02:28:46 +00:00Commented Oct 23, 2015 at 2:28
-
(1) he needs to consider whether to upgrade, and (2) he needs to study the docs on such plugins. I think this is a case where "go see X" is a sufficient answer.Rick James– Rick James2015年10月23日 02:32:37 +00:00Commented Oct 23, 2015 at 2:32
-
Ok if you feel this answer is as good as it can possibly be then that is your prerogative.Erik– Erik2015年10月23日 02:38:25 +00:00Commented Oct 23, 2015 at 2:38
-
Upon a cursory glance, it seems that this is backported to 55, but that it requires an Enterprise license. Therefore, its a good option, but not an option in this environment.Justin Dearing– Justin Dearing2015年10月26日 20:26:38 +00:00Commented Oct 26, 2015 at 20:26
lang-sql