Telegraf mysql input - what user rights on the database?

Telegraf
6

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.

https://dev.mysql.com/doc/refman/8.0/en/show-status.html

Antony.