# PMM v2 (AWS AMI) Query Analytics not working for MySQL RDS

**URL:** <https://forums.percona.com/t/pmm-v2-aws-ami-query-analytics-not-working-for-mysql-rds/8398>\
**Category:** PMM 2.x\
**Created:** [December 16, 2020, 8:55am UTC](https://forums.percona.com/t/pmm-v2-aws-ami-query-analytics-not-working-for-mysql-rds/8398 "2020-12-16T08:55:35Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![zerg2k](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zerg2k/32/2828_2.png) [@zerg2k](https://forums.percona.com/u/zerg2k)\
**Post date:** [December 16, 2020, 8:55am UTC](https://forums.percona.com/t/pmm-v2-aws-ami-query-analytics-not-working-for-mysql-rds/8398/1 "2020-12-16T08:55:35Z")

</div>

Hello,

I have MySQL RDS 8.0.17 with performance\_schema ON

Yet the Query Analytics panel doesnot even shows the instance.

Is there something else I need to do ?

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [December 17, 2020, 12:30pm UTC](https://forums.percona.com/t/pmm-v2-aws-ami-query-analytics-not-working-for-mysql-rds/8398/2 "2020-12-17T12:30:29Z")

</div>

Hi, please review [https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html#perf-schema](https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html#perf-schema)

also make sure the PMM user has proper grants e.g.

GRANT SELECT, PROCESS, REPLICATION CLIENT, RELOAD ON _._ TO ‘pmm’@‘%’ IDENTIFIED BY ‘\*\*\*\*\*’ WITH MAX\_USER\_CONNECTIONS 10;

GRANT SELECT, UPDATE, DELETE, DROP ON performance\_schema.\* TO ‘pmm’@‘%’;

---

<div class="post-metadata">

**Author:** ![zerg2k](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zerg2k/32/2828_2.png) [@zerg2k](https://forums.percona.com/u/zerg2k)\
**Post date:** [December 21, 2020, 8:41am UTC](https://forums.percona.com/t/pmm-v2-aws-ami-query-analytics-not-working-for-mysql-rds/8398/3 "2020-12-21T08:41:45Z")

</div>

Ok I am going to close the circle.

Firsts, Thanks to all those that tried to help! Username, Password and security settings had all been granted from the start.

What happened was that there were Permission Policies blocking the access on the target VPC.

It would be nice if we can add a “test” button at instance addition time so that people can check then and there to know if something is not right and not silently take the settings.

Thanks again!

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [December 21, 2020, 8:51am UTC](https://forums.percona.com/t/pmm-v2-aws-ami-query-analytics-not-working-for-mysql-rds/8398/4 "2020-12-21T08:51:18Z")

</div>

Thanks for the additional info. I will check with the dev team about your suggestion.