Steps to Configure MySQL Plugin for UNIX Socket:

Obtain the MySQL Socket File Path:

First, you need to identify the location of the MySQL socket file by running the following query in your MySQL client.

SHOW VARIABLES LIKE 'socket';

This will return the path of the socket file, which is typically /var/run/mysqld/mysqld.sock but may vary depending on your system configuration.

Update MySQL agent Configuration:

Once you have the socket path, you can update the /etc/atatus-infra-agent/conf.d/mysql.d/mysql.yml configuration file.

   metrics:
   - hosts: ["unix(/var/run/mysqld/mysqld.sock)/"]
     username: atatus
     password: <UNIQUEPASSWORD>
     dbm: true