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>