About Mysql RDS audit

Question

Good afternoon.

Is there an easy way to audit DML and DDL in MYSQL 5.7?

I know Oracle and SQLSERVER but I haven't found an easy way to implement this in the database.

Mikel Del Tio · Accepted Answer

Hi,

According to [AWS documentation](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.MySQL.Options.AuditPlugin.html), you can use the MariaDB Audit Plugin for MySQL that records database activity (including  DCL, DDL and DML query events) and is compatible with all MySQL 5.7 versions.

Take a look at the following [Knowledge Center article](https://aws.amazon.com/blogs/database/configuring-an-audit-log-to-capture-database-activities-for-amazon-rds-for-mysql-and-amazon-aurora-with-mysql-compatibility/) which describes how to configure it.

rePost-User-9651737 · Answer

Hi Mikel

hunn, I read this material but in my case dude is the my database is MySQL Community, 5.7 ....the parameters its different .

About Mysql RDS audit

Relevant content