[Nagiosplug-help] i need help with check_mysql?

[John Lewis]

Reading http://dev.mysql.com/doc/refman/5.1/en/adding-users.html it seems like the user for nagios at localhost needs to be created in the database you are trying to grant it access to.

Did you create the user nagios at localhost in the database?

Lewis

On May 4, 2011, at 3:16 PM, The Sinner wrote:

> hi all,
> 
> i receive access denied for user 'nagios'@'localhost' (using password no) error.
> 
> what i did so far:
> 
> logged in to mysql and selected mysql database then:
> > grant all privileges on *.* to 'nagios'@'localhost' identified by 'mypass';
> > flush privileges;
> 
> then wrote a service to run the check_mysql command.
> 
> the service is like:
> 
> ...
> ...                 check_mysql!-H localhost -d mysql -u nagios -p mypass
> ...
> 
> how should i modify the bold part in my service definition not to receive the error above? do i miss something or write a wrong check_mysql service command?
> 
> thanks in advance.
> 
> -- 
> The Sinner
> ------------------------------------------------------------------------------
> WhatsUp Gold - Download Free Network Management Software
> The most intuitive, comprehensive, and cost-effective network 
> management toolset available today.  Delivers lowest initial 
> acquisition cost and overall TCO of any competing solution.
> http://p.sf.net/sfu/whatsupgold-sd_______________________________________________
> Nagiosplug-help mailing list
> Nagiosplug-help at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagiosplug-help
> ::: Please include plugins version (-v) and OS when reporting any issue. 
> ::: Messages without supporting info will risk being sent to /dev/null

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-plugins.org/archive/help/attachments/20110504/16a70534/attachment.html>