# Super privileges for pmm user

**URL:** <https://forums.percona.com/t/super-privileges-for-pmm-user/6802>\
**Category:** PMM 1.x\
**Created:** [January 16, 2019, 9:26pm UTC](https://forums.percona.com/t/super-privileges-for-pmm-user/6802 "2019-01-16T21:26:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![PavelS](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavels/32/5660_2.png) [@PavelS](https://forums.percona.com/u/PavelS)\
**Post date:** [January 16, 2019, 9:26pm UTC](https://forums.percona.com/t/super-privileges-for-pmm-user/6802/1 "2019-01-16T21:26:55Z")

</div>

Hello Everybody!  
I’ve recently installed pm-server it’s pretty nice and very useful.  
But it requires SUPER privilege to pmm mysql user. I’m not quite sure is it safe to grant SUPER privilege to monitoring account.  
Am I wrong, and it completely safe? Or there is any way to avoid this?

---

<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 17, 2019, 11:17am UTC](https://forums.percona.com/t/super-privileges-for-pmm-user/6802/2 "2019-01-17T11:17:19Z")

</div>

Hi PavelS,  
There are a couple of reasons we ask for SUPER privileges:

- With MySQL there is the concept of exhausting all available connections up to max\_connections server variable, however since 5.1 MySQL permits one more connection to those users with SUPER - the thinking here is that we still allow the monitoring application to log in and provide an understanding of what is going on within the server, in order to troubleshoot. Without this connection, you will be blind.
- Without SUPER we will then lose the ability to modify server variables around Query Analytics - slow log rotation, etc

So in other words - PMM will still work without SUPER however it will operate with lesser functionality if you revoke this privilege.

Privileges required for PMM & MySQL full functionality: [Percona Monitoring and Management](https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html#id1)  
How SUPER maintains visibility of your database activity: [MySQL :: MySQL 8.0 Reference Manual :: B.3.2.5 Too many connections](https://dev.mysql.com/doc/refman/8.0/en/too-many-connections.html)
