Is there a simple check to see if MySQL is up on a host with Nagios without authenticating and selecting a table?
Mysql – Simple check to see if thesql is up with Nagios
monitoringMySQLnagios
monitoringMySQLnagios
Is there a simple check to see if MySQL is up on a host with Nagios without authenticating and selecting a table?
Best Answer
You can check by using tcp connections, but authenticating is definitely preferred.
One other thing to keep in mind, without authenticating properly eventually mysql will block your monitoring host for remote mysql connections due to errors and you'll have to run 'mysqladmin flush' to give it access again.