The problem of https://bugs.mysql.com/bug.php?id=77553 is still present.
If I try to set audit_log_include_accounts or audit_log_exclude_accounts variables, they work with user@localhost but they don't work with user@127.0.0.1.
When
set global audit_log_include_accounts = 'user@localhost';
There was the audit for each action depending audit_log_policy
"Connect","6078172_2017-02-09T17:06:19","2017-02-10T08:17:20 UTC","1699",0,"user","user","","''@''","localhost","",""
"Quit","6078173_2017-02-09T17:06:19","2017-02-10T08:17:22 UTC","1699",0,"user","user","","''@''","localhost","",""
When I've tried one of the set below
set global audit_log_include_accounts = 'user@127.0.0.1';
set global audit_log_include_accounts = "'user'@'127.0.0.1'";
set global audit_log_include_accounts = '\'user\'@\'127.0.0.1\'';
There was nothing the audit.
Vice versa, when
set global audit_log_exclude_accounts = 'user@localhost';
There was nothing the audit.
When I've tried one of the set below
set global audit_log_exclude_accounts = 'user@127.0.0.1';
set global audit_log_exclude_accounts = "'user'@'127.0.0.1'";
set global audit_log_exclude_accounts = '\'user\'@\'127.0.0.1\'';
There was the audit for each action depending audit_log_policy
"Connect","6078184_2017-02-09T17:06:19","2017-02-10T08:59:09 UTC","1803",0,"user","user","","","","127.0.0.1",""
"Query","6078185_2017-02-09T17:06:19","2017-02-10T08:59:09 UTC","select","1803",0,"select @@version_comment limit 1","user[user] @ [127.0.0.1]","","","127.0.0.1",""
"Quit","6078186_2017-02-09T17:06:19","2017-02-10T08:59:14 UTC","1803",0,"user","user","","","","127.0.0.1",""
Version
- Percona Server 5.6.33-79.0 2084bdb
- Centos 7.3.1611