# MySQL DB Auditlog issue

**URL:** <https://forums.percona.com/t/mysql-db-auditlog-issue/15778>\
**Category:** Other MySQL® Questions\
**Tags:** mysql, closed-no-reply\
**Created:** [May 23, 2022, 5:36am UTC](https://forums.percona.com/t/mysql-db-auditlog-issue/15778 "2022-05-23T05:36:32Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ArulJ](https://avatars.discourse-cdn.com/v4/letter/a/e19b73/32.png) [@ArulJ](https://forums.percona.com/u/ArulJ)\
**Post date:** [May 23, 2022, 5:36am UTC](https://forums.percona.com/t/mysql-db-auditlog-issue/15778/1 "2022-05-23T05:36:32Z")

</div>

I have Mysql instance with audit log enabled.  
Below is a line from audit.log . Here if you see , the db is shown empty. for few entries, I have seen db is populated correctly in the audit.log file

{“audit\_record”:{“name”:“Query”,“record”:“1557033666\_2022-05-16T10:48:25”,“timestamp”:“2022-05-19T10:12:24Z”,“command\_class”:“select”,“connection\_id”:“12”,“status”:0,“sqltext”:“SELECT DriversLicenseIDNumber FROM data1”,“user”:“root[root] @ localhost ”,“host”:“localhost”,“os\_user”:“”,“ip”:“”,“db”:“”}}

A good audit log as below:

{“audit\_record”:{“name”:“Query”,“record”:“1557076254\_2022-05-16T10:48:25”,“timestamp”:“2022-05-20T05:22:32Z”,“command\_class”:“update”,“connection\_id”:“25”,“status”:0,“sqltext”:“UPDATE accountdetails1 SET id= ‘888’ WHERE id= ‘102’”,“user”:“root[root] @ localhost [127.0.0.1]”,“host”:“localhost”,“os\_user”:“”,“ip”:“127.0.0.1”,“db”:“test\_db”}}