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