MySQL
Introduction
The MySQL probe collects information about a MySQL server.
Probe configuration
Make sure your MySQL server is accessible
You can edit the files in /etc/mysql/ to configure the basic settings – log file, port number, etc. For example, to configure MySQL to listen for connections from network hosts, in the file /etc/mysql/mysql.conf.d/mysqld.cnf, change the bind-address directive to the server’s IP address:
bind-address = 0.0.0.0
Create an infrasonar user and provide the required privileges:
CREATE USER 'infrasonar' IDENTIFIED BY '<MY_SECRET_PASSWORD>';
GRANT SELECT, PROCESS, REFERENCES on *.* TO 'infrasonar';
Configure the username and password in our remote appliance manager.