# Audit Log Filter Doesn't accept user@%

**URL:** <https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612>\
**Category:** Percona Distribution for MySQL\
**Created:** [April 10, 2026, 11:25am UTC](https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612 "2026-04-10T11:25:16Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![IGGt](https://avatars.discourse-cdn.com/v4/letter/i/67e7ee/32.png) [@IGGt](https://forums.percona.com/u/IGGt)\
**Post date:** [April 10, 2026, 11:25am UTC](https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612/1 "2026-04-10T11:25:16Z")

</div>

I am running the audit\_log\_filter component with MySQL 8.4.8 (Oracle MySQL).

If I run:

`SELECT audit_log_filter_set_user(‘%’, ‘log_connections_and_queries’);`

it works fine.

If I run:

`SELECT audit_log_filter_set_user(‘user@localhost’, ‘log_connections_and_queries’);`

it works fine.

But if I try and run:

`SELECT audit_log_filter_set_user(‘user@%’, ‘log_connections_and_queries’);`

I get:

Error Code: 1123. Can’t initialize function ‘audit\_log\_filter\_set\_user’; Wrong argument: bad host name format

Is there a way to add “user@%”.

I tried removing all other user entries first, using a different filter name. But it seems that it simply doesn’t like “user@%”

---

<div class="post-metadata">

**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\
**Post date:** [April 10, 2026, 11:51am UTC](https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612/2 "2026-04-10T11:51:25Z")

</div>

Try your command like this:

```auto
SELECT audit_log_filter_set_user('user@%', 'log_connections_and_queries');

```

Notice I changed from the ‘ ’ (smart quotes) to ’ '.

---

<div class="post-metadata">

**Author:** ![IGGt](https://avatars.discourse-cdn.com/v4/letter/i/67e7ee/32.png) [@IGGt](https://forums.percona.com/u/IGGt)\
**Post date:** [April 10, 2026, 12:07pm UTC](https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612/3 "2026-04-10T12:07:45Z")

</div>

Still the same. I also tried “ “. No difference.

---

<div class="post-metadata">

**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\
**Post date:** [April 10, 2026, 12:10pm UTC](https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612/4 "2026-04-10T12:10:16Z")

</div>

Are you running MySQL Community or Oracle MySQL Enterprise?

---

<div class="post-metadata">

**Author:** ![IGGt](https://avatars.discourse-cdn.com/v4/letter/i/67e7ee/32.png) [@IGGt](https://forums.percona.com/u/IGGt)\
**Post date:** [April 10, 2026, 12:11pm UTC](https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612/5 "2026-04-10T12:11:01Z")

</div>

MySQL Community Edition

---

<div class="post-metadata">

**Author:** ![Wayne\_Leutwyler](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wayne_leutwyler/32/20829_2.png) [@Wayne\_Leutwyler](https://forums.percona.com/u/Wayne_Leutwyler)\
**Post date:** [April 10, 2026, 12:18pm UTC](https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612/6 "2026-04-10T12:18:42Z")

</div>

What is the output from this:

```auto
SELECT @@version, @@version_comment;

```

---

<div class="post-metadata">

**Author:** ![IGGt](https://avatars.discourse-cdn.com/v4/letter/i/67e7ee/32.png) [@IGGt](https://forums.percona.com/u/IGGt)\
**Post date:** [April 10, 2026, 12:21pm UTC](https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612/7 "2026-04-10T12:21:26Z")

</div>

> [@Wayne\_Leutwyler](#):
>
> `SELECT @@version, @@version_comment;`

| 8.4.8 | MySQL Community Server - GPL |
| --- | --- |

---

<div class="post-metadata">

**Author:** ![IGGt](https://avatars.discourse-cdn.com/v4/letter/i/67e7ee/32.png) [@IGGt](https://forums.percona.com/u/IGGt)\
**Post date:** [April 10, 2026, 12:34pm UTC](https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612/8 "2026-04-10T12:34:25Z")

</div>

I just tried this on a test server, withe the same OS and MySQL version, and of course, it works fine on there. So it seems there is something about my setup it doesn’t like.

---

<div class="post-metadata">

**Author:** ![jrivera](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jrivera/32/13_2.png) [@jrivera](https://forums.percona.com/u/jrivera)\
**Post date:** [April 10, 2026, 9:53pm UTC](https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612/9 "2026-04-10T21:53:56Z")

</div>

Old versions of the audit log filter component had a bug like this - [PS-9024](https://perconadev.atlassian.net/browse/PS-9024)

---

<div class="post-metadata">

**Author:** ![IGGt](https://avatars.discourse-cdn.com/v4/letter/i/67e7ee/32.png) [@IGGt](https://forums.percona.com/u/IGGt)\
**Post date:** [April 13, 2026, 11:00am UTC](https://forums.percona.com/t/audit-log-filter-doesnt-accept-user/40612/10 "2026-04-13T11:00:42Z")

</div>

It looks like I had installed an older version of the component by mistake. I copied the working one across and installed that, and it now seems to be fine.