MySQL Enterprise Audit uses tables in the
database for persistent storage of filter and user account
data. The tables can be accessed only by users with privileges
for that database. The tables use the
InnoDB storage engine
MyISAM prior to MySQL 5.7.21).
If these tables are missing, the
plugin operates in legacy mode. See
Section 6.5.7, “Legacy Mode Audit Log Filtering”.
audit_log_filter table stores filter
definitions. The table has these columns:
The filter name.
The filter definition associated with the filter name. Definitions are stored as
audit_log_user table stores user
account information. The table has these columns:
The user name part of an account. For an account
The host name part of an account. For an account
The name of the filter assigned to the account. The filter name associates the account with a filter defined in the