MySQL Required Privileges?

Elastic Stack Beats
1

I'm new to elastic and metricbeat, but I'd like to set up the mysql module with a user account that has the least required privileges. The example shows "root@" and the question about privileges was never answered in this earlier thread…

Stuck with MySQL permission

Does anyone know the incantation to create a mysql user with the correct privileges for the metricbeat mysql module to collect stats?

2

I believe the mysql status metricset only does show global status; and I think any user can run the query. So try a user with only the GRANT USAGE privilege.

1 Like
3

Thanks, Andrew!

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.