This is an old revision of the document!

MySQL Performance Data

This is the config used to allow nagios user to connect over the network in order to extract performance data.

Create user

mysql> GRANT usage ON *.* TO 'nagios'@'10.10.10.0/255.255.255.0' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)
 
mysql> GRANT usage ON *.* TO 'nagios'@'localhost' IDENTIFIED BY 'password';
Query OK, 0 rows affected (0.00 sec)
 
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
 
mysql>