In order to change the type of events recorded to the audit log file, the policy settings must be changed. This is done with the mysqlauditadmin utility using the command 'policy' and specifying the desired policy value with the --value option. As expected the specification of the target server is also required using the --server option.

In the above example, the policy value was set to LOGINS to write only login events to the log file. Nevertheless, other values are also permitted to control the information written to the log file: ALL (write all events), QUERIES (write only query event), NONE (disable logging), DEFAULT (use the default policy).

User Comments
Sign Up Login You must be logged in to post a comment.