Permissions for MySQL Monitoring Extension

[technical_admin]

When trying to enable the extension I have to provide a user/password. However there is no indication what permissions this user account needs to have. Is it enough if he has the MonitorAdmin permissions?

[Jakub_Mierzewsk]

We don't require any special permissions. MonitorAdmin permissions should be enough.

[giovanni_gibili]

For those who were wandering MonitorAdmin is the Workbench name for the PROCESS permission on MySQL. http://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html#priv_process

[Jakub_Mierzewsk · Accepted solution]

In MySQL monitoring we use show global status (http://dev.mysql.com/doc/refman/5.7/en/show-variables.html) and show global variables (http://dev.mysql.com/doc/refman/5.7/en/show-status.html)
they don’t
require any specific privileges, only an ability to connect to the server is
needed.

[kalle_lahtinen]

Thanks Jakub! This is the only place where I found this info. I wonder why there's no setup documentation for the MySQL plugin, like there is e.g. for https://www.dynatrace.com/support/help/technology-support/application-software/other-technologies/su...

https://www.dynatrace.com/support/help/technology-support/application-software/other-technologies/su... returns 404.

[gsaharan]

Hi everyone, 

We are process with the installation of this extension, do we know any extra permission that is still required for this extension, as i see this blog to be pretty old.

[david_lopes · Accepted solution]

The permissions and even the GRANT statements are documented in the extension docs: https://docs.dynatrace.com/docs/observe/applications-and-microservices/databases/extensions/mysql-re...