# No username no database name in Query Analytics dashboard

**URL:** <https://forums.percona.com/t/no-username-no-database-name-in-query-analytics-dashboard/7591>\
**Category:** PMM 2.x\
**Created:** [April 30, 2020, 8:33am UTC](https://forums.percona.com/t/no-username-no-database-name-in-query-analytics-dashboard/7591 "2020-04-30T08:33:53Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![montesuma](https://avatars.discourse-cdn.com/v4/letter/m/b5ac83/32.png) [@montesuma](https://forums.percona.com/u/montesuma)\
**Post date:** [April 30, 2020, 8:33am UTC](https://forums.percona.com/t/no-username-no-database-name-in-query-analytics-dashboard/7591/1 "2020-04-30T08:33:53Z")

</div>

Hi, I use PMM v2.4.0 for query analytics. Everything looks fine except absence of username and database in grafana dashboard.&nbsp;Schema name is present. PMM user grants are:  
  
GRANT SELECT, RELOAD, PROCESS, SUPER, REPLICATION CLIENT ON _._ TO `pmm`@`%`  
  
GRANT SELECT ON `performance_schema`.\* TO `pmm`@`%`  
Percona server version is 8.0.16  
What I’m doing wrong?

---

<div class="post-metadata">

**Author:** ![steve.hoffman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/steve.hoffman/32/66_2.png) [@steve.hoffman](https://forums.percona.com/u/steve.hoffman)\
**Post date:** [May 1, 2020, 8:36am UTC](https://forums.percona.com/t/no-username-no-database-name-in-query-analytics-dashboard/7591/2 "2020-05-01T08:36:38Z")

</div>

Are you able to get other metrics from the server (i.e. normal exporter data)?&nbsp; If I’m reading your issue correctly you were able to add the node with the performance schema flag successfully but nothing is showing on the QAN dashboard for this node?

---

<div class="post-metadata">

**Author:** ![montesuma](https://avatars.discourse-cdn.com/v4/letter/m/b5ac83/32.png) [@montesuma](https://forums.percona.com/u/montesuma)\
**Post date:** [May 1, 2020, 9:00am UTC](https://forums.percona.com/t/no-username-no-database-name-in-query-analytics-dashboard/7591/3 "2020-05-01T09:00:07Z")

</div>

I can see metrics from mysqld\_exporter and node\_exporter like&nbsp; MySQL Performance Schema Details or MySQL User Details. But in Query Analitics dashboard in left pane User and Database sections are 100% n/a&nbsp;&nbsp;

---

<div class="post-metadata">

**Author:** ![Stateros](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/stateros/32/2490_2.png) [@Stateros](https://forums.percona.com/u/Stateros)\
**Post date:** [May 1, 2020, 9:11am UTC](https://forums.percona.com/t/no-username-no-database-name-in-query-analytics-dashboard/7591/4 "2020-05-01T09:11:46Z")

</div>

It looks like you haven’t enabled slow\_query\_log, or slow\_query time very high, or slow\_query\_log is empty. Check your preferences and slow\_query\_log is filling.&nbsp;

---

<div class="post-metadata">

**Author:** ![montesuma](https://avatars.discourse-cdn.com/v4/letter/m/b5ac83/32.png) [@montesuma](https://forums.percona.com/u/montesuma)\
**Post date:** [May 3, 2020, 10:52am UTC](https://forums.percona.com/t/no-username-no-database-name-in-query-analytics-dashboard/7591/5 "2020-05-03T10:52:17Z")

</div>

I added new service to ppm agent with source slow log and now I can see usernames from slow log entries but usernames from performance.schema&nbsp; source still unavailable as a filter 😕

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [May 3, 2020, 2:23pm UTC](https://forums.percona.com/t/no-username-no-database-name-in-query-analytics-dashboard/7591/6 "2020-05-03T14:23:30Z")

</div>

Performance Schema data source does not provide user names. If you want to see user names you need to use Slow Query Log as data source at this point.

---

<div class="post-metadata">

**Author:** ![montesuma](https://avatars.discourse-cdn.com/v4/letter/m/b5ac83/32.png) [@montesuma](https://forums.percona.com/u/montesuma)\
**Post date:** [May 3, 2020, 5:24pm UTC](https://forums.percona.com/t/no-username-no-database-name-in-query-analytics-dashboard/7591/7 "2020-05-03T17:24:55Z")

</div>

ok thank you for clarification
