MySQL Required Privileges?


#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?


(Andrew Kroh) #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.


#3

Thanks, Andrew!


(system) #4

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