Site icon Database Tutorials

MySQL Auditing

 

MySQL Community Edition:

MySQL Community Edition having feature of auditing but I cannot having feature  filter the users

To activate audit log:

 

To disable audit log:

 

You can also do these setting in my.cnf

 

MySQL Enterprise Edition:

MySQL Community Edition having feature of auditing and it have several extended features

Check out the audit_log.so in the server. It must be there after the installation of MySQL Enterprise Edition

 

After the successful installation of .so on mysql configure and activate the auditing as per your requirement by the following commands

 

To Enable Auditing for specific Account do the following addition to My.CNF file of MySQL Instance

 

You can enable several filtration on auditing like Specific Tables,SQL Queries , User Accounts, Hosts etc. One of the example are as follows i.e. enable auditing for specific user accounts only.

Exit mobile version