Hello.
The MySQL/MariaDB connector stores the credentials in the monitored host's macros.
The problem is that if I need to have a service that connects to the server of that monitored host but with another user, there is no way to override the "default" credentials from the host's macros.
We have several MySQL servers with several databases and users in each that we need to monitor.
So for now, you need to create a new monitored host (for the same server) with those credentials or use a modified command based on the one provided by the connector.
Could it be possible to add that functionality (overriding the credential stored in the host) to the service templates for the MySQL/MariaDB connector? That also be consistent with how other connectors work, which allow to override macro's values stored in the host with its own macros or passed as options in the EXTRAOPTIONS macro (for example, hostname, protocol, port...).
The connector allows to specify a database and port to connect to; it would seem normal it also allows to set the credentials if needed.
Regards.
