Nagios MySQL Monitoring

[Tzogii13]

I have question regarding Nagios MySQL Monitoring. At the moment I can monitor MySQL, however it is showing everything as critical. When I try and run my commands from the command line I keep getting this error and I am not sure why.

OUTPUT: CRITICAL - cannot connect to information_schema. Access denied for user 'root'@'dhcp-0-1e-4c-8a-79-d5.cpe.powergate.ca' (using password: YES)

Thanks in advance

[tmcdonald]

Do you allow root logins on that MySQL server?

http://serverfault.com/questions/238277 ... sql-plugin

[Tzogii13]

Sorry, what do you mean?

[tmcdonald]

From the article I linked:

The default setting for a MySQL server is to deny access from clients with IP addresses other than the server address. To get around this, run the following command on your server:

Code: Select all

# mysql -u root
mysql> grant select on [DB name you're checking].* to 'nagios_user'@'[Nagios server IP address or hostname]' identified by '[password for nagios_user]';
mysql> flush privileges;  

This will need to be done on the remote MySQL server in order for the Nagios server to run queries on it.