MySQL Enterprise Audit SELECT audit_log_filter_remove_filter(’log_nothing’); Removing a filter also unassigns it from any users to whom it has been assigned, including any current sessions for those users. The filtering functions just described affect audit filtering immediately and update the audit log tables in the  mysql  system database that store filters and user accounts (see Audit Log Tables). It is also possible to modify the audit log tables directly using statements such as  INSERT ,  UPDATE , and  DELETE , but such changes do not affect filtering immediately. To flush your changes and make them operational, call audit_log_filter_flush() SELECT audit_log_filter_flush(); audit_log_filter_flush()  should be used only after modifying the audit tables directly, to force reloading all filters. Otherwise, this function should be avoided. It is, in effect, a simplified version of unloading and reloading the audit_log  plugin with  UNINSTALL PLUGIN  plus  INSTALL PLUGIN . audit_log_filter_flush()  affects all current sessions and detaches them from their previous filters. Current sessions are no longer logged unless they disconnect and reconnect, or execute a change-user operation. To determine whether a filter has been assigned to the current session, check the session value of the read-only  audit_log_filter_id  system variable. If the value is 0, no filter is assigned. A nonzero value indicates the internally maintained ID of the assigned filter: { "filter":  actions  } Filter definitions are  JSON  values. For information about using  JSON  data in MySQL, see Section 11.5, “The JSON Data Type” . Filter definitions have this form, where  actions  indicates how filtering takes place: The following discussion describes permitted constructs in filter definitions. •Logical Operators •Blocking Execution of Specific Events •Testing Event Field Values •Inclusive and Exclusive Logging •Logging Specific Event Subclasses •Logging Specific Event Classes •Logging All Events 6.4.5.8 Writing Audit Log Filter Definitions mysql>  SELECT @@audit_log_filter_id; +-----------------------+ | @@audit_log_filter_id | +-----------------------+ | 2 | +-----------------------+ Warning 1505