# How to Read MySQL Audit log through PMM

**URL:** <https://forums.percona.com/t/how-to-read-mysql-audit-log-through-pmm/13956>\
**Category:** PMM 2.x\
**Created:** [January 18, 2022, 5:03am UTC](https://forums.percona.com/t/how-to-read-mysql-audit-log-through-pmm/13956 "2022-01-18T05:03:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![simson.rif](https://avatars.discourse-cdn.com/v4/letter/s/7cd45c/32.png) [@simson.rif](https://forums.percona.com/u/simson.rif)\
**Post date:** [January 18, 2022, 5:03am UTC](https://forums.percona.com/t/how-to-read-mysql-audit-log-through-pmm/13956/1 "2022-01-18T05:03:45Z")

</div>

Hi Team,  
Is there any way to read mysql enterprise audit log file thorugn PMM2-Server ?

Thanks  
Ferdous

---

<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:** [January 18, 2022, 2:25pm UTC](https://forums.percona.com/t/how-to-read-mysql-audit-log-through-pmm/13956/2 "2022-01-18T14:25:12Z")

</div>

See if this helps you. This is a post on how to get your audit logs into a table, and then you can use the PMM Security Threat tool to create alarms on audit actions. For simply browsing the logs, no, there is nothing like that in PMM.

> **[Percona Audit Log Plugin and the Percona Monitoring and Management Security...](https://www.percona.com/blog/2020/07/22/percona-audit-log-plugin-and-the-percona-monitoring-and-management-security-threat-tool/)**
>
> Thinking about ways to improve database security, the obvious data source was clear: the Percona Audit Log Plugin for Percona Monitoring and Management.

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [January 18, 2022, 5:36pm UTC](https://forums.percona.com/t/how-to-read-mysql-audit-log-through-pmm/13956/3 "2022-01-18T17:36:01Z")

</div>

Just adding to what @matthewb said - while there is no official support for ingesting Audit logs into PMM, there is a side project I’ve been following called clickhouseimporter that will consume audit logs and insert them into ClickHouse. It doesn’t come with a GUI, but it does get you to the point where you can then use SQL to peruse your logs. I hope this helps!

> **[GitHub - Lenny-hos-stofa/clickhouseimporter: a simple tool for importing...](https://github.com/Lenny-hos-stofa/clickhouseimporter)**
>
> a simple tool for importing Percona Audit Logs into Clickhouse - GitHub - Lenny-hos-stofa/clickhouseimporter: a simple tool for importing Percona Audit Logs into Clickhouse

---

<div class="post-metadata">

**Author:** ![meyerder](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/meyerder/32/16994_2.png) [@meyerder](https://forums.percona.com/u/meyerder)\
**Post date:** [January 21, 2022, 11:14pm UTC](https://forums.percona.com/t/how-to-read-mysql-audit-log-through-pmm/13956/4 "2022-01-21T23:14:49Z")

</div>

While not all PMM it is close and works very well for me

Enable Audit Plugin  
Set Audit scope (to what you want to audit and for how long)  
Set audit log format = json  
Install Promtail to send to loki instance  
Add Loki Service to the PMM as a data source  
Design a new Dasbhoard in Grafana to meet what you need