Why PMM User need Super privileges?

[mramirez]

Hello,
I’ve recently installed pm-server 2.12. But it requires SUPER privilege to pmm mysql user in Mysql Clients Server. This is not safe to grant SUPER privilege for à monitoring account.

If PMM “not modified data” in database client, why is nessesary to grant this super privilege ?

I saw that it’s nessesary to permits one more connection to those users (max_connecitions server variable) .

What are the others functionality not work if i revoke this privilege?.

Thanks for your help
best regards.

[matthewb]

Please see the answer here:

Super privileges for pmm user

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 wil…