Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add new user for general monitoring #5477

Closed
derekperkins opened this issue Nov 27, 2019 · 0 comments · Fixed by #5486
Closed

Add new user for general monitoring #5477

derekperkins opened this issue Nov 27, 2019 · 0 comments · Fixed by #5486
Labels
Type: Enhancement Logical improvement (somewhere between a bug and feature)

Comments

@derekperkins
Copy link
Member

I think it would be generally useful to add a default monitoring user with minimal permissions that cover a standard range of MySQL collection agents. Here is a set pulled from the datadog docs:

mysql> GRANT REPLICATION CLIENT ON *.* TO 'monitoring'@'localhost' WITH MAX_USER_CONNECTIONS 5;

mysql> GRANT PROCESS ON *.* TO 'monitoring'@'localhost';

For MySQL 8.0+ set max_user_connections with:
mysql> ALTER USER 'monitoring'@'localhost' WITH MAX_USER_CONNECTIONS 5;

mysql> GRANT SELECT ON performance_schema.* TO 'monitoring'@'localhost';
@morgo morgo added Type: Enhancement Logical improvement (somewhere between a bug and feature) patch-pending labels Nov 28, 2019
systay pushed a commit that referenced this issue Jul 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Type: Enhancement Logical improvement (somewhere between a bug and feature)
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants