# Comment in CREATE / ALTER / DROP / GRANT user command is not written into audit.log

**URL:** <https://forums.percona.com/t/comment-in-create-alter-drop-grant-user-command-is-not-written-into-audit-log/30456>\
**Category:** Percona Server for MySQL 8.0\
**Tags:** percona\
**Created:** [May 21, 2024, 9:19am UTC](https://forums.percona.com/t/comment-in-create-alter-drop-grant-user-command-is-not-written-into-audit-log/30456 "2024-05-21T09:19:26Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tony\_Jang](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/tony_jang/32/16488_2.png) [@Tony\_Jang](https://forums.percona.com/u/Tony_Jang)\
**Post date:** [May 21, 2024, 9:19am UTC](https://forums.percona.com/t/comment-in-create-alter-drop-grant-user-command-is-not-written-into-audit-log/30456/1 "2024-05-21T09:19:26Z")

</div>

Hello.

We are using percona audit log for MySQL 8  
When we execute DDL on database, we add JIRA ticket as a comment in command like  
“CREATE /\* XXX-0000 \*/ TABLE”  
Normally, command including comment is written into audit.log.

{“audit\_record”:{“name”:“Query”,“record”:“138720\_2023-03-15T04:35:13”,“timestamp”:“2023-09-20T06:04:15Z”,“command\_class”:“alter\_table”,“connection\_id”:“15569375”,“status”:0,“sqltext”:“alter /\* XXX-0000 \*/ table `database_name`.table\_name alter index index\_name invisible”,“user”:“user\_name[user\_name] @ [127.0.0.1]”,“host”:“”,“os\_user”:“”,“ip”:“127.0.0.1”,“db”:“”,“rows”:“0”}}

But when we execute user related command (CREATE / ALTER / DROP / GRANT user), the comment is not written into audit.log, just only command is written.

{“audit\_record”:{“name”:“Query”,“record”:“138789\_2023-03-15T04:35:13”,“timestamp”:“2023-10-04T11:50:59Z”,“command\_class”:“alter\_user”,“connection\_id”:“17157640”,“status”:0,“sqltext”:“ALTER USER ‘user\_name’@‘127.0.0.1’ IDENTIFIED BY ”,“user”:“user\_name[user\_name] @ [127.0.0.1]”,“host”:“”,“os\_user”:“”,“ip”:“127.0.0.1”,“db”:“”,“rows”:“0”}}

Does anyone know the reason or solution?

Thank you.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [May 21, 2024, 2:54pm UTC](https://forums.percona.com/t/comment-in-create-alter-drop-grant-user-command-is-not-written-into-audit-log/30456/2 "2024-05-21T14:54:34Z")

</div>

Hi @Tony_Jang, this sounds like a bug. Please open a JIRA at [https://jira.percona.com/](https://jira.percona.com/) and provide these examples.