I want to monitor databases with the mysql input plugin for telegraf.
For this i want to create a dedicated user on each database server that can only connect from my host that runs telegraf.
…and for the life of me I can’t find any docs that tell me what permissions that user needs…
Any hints for me?
Okay, that looks like it’s almost certainly using the “show status” MySQL
command. You do not need any privileges to run this command other than an
account which can connect.