Audit_log_filter component and MySQL 8.4

MySQL & MariaDB Other MySQL® Questions
13

The statement

SELECT audit_log_filter_set_user('test@localhost', 'log_all');

produces an error because it seems log_all filter doesn’t exist.

You can check with query :

select * from audit_log.audit_log_filter where filter = 'log_all';

But as your INSERT statement generate an error in log, previous query will display no result.

You don’t use the right method to add filter, the official method to add filter is to use the component function :

SELECT audit_log_filter_set_filter('log_all',filter_rule);

And in your case, the filter rule exceeds the maximum authorised limit of 1024 characters.
You can find an answer to write the correct rule in this thread : Write audit_log_filter definitons