<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Reading <a href="http://dev.mysql.com/doc/refman/5.1/en/adding-users.html">http://dev.mysql.com/doc/refman/5.1/en/adding-users.html</a> it seems like the user for nagios@localhost needs to be created in the database you are trying to grant it access to.</div><div><br></div>Did you create the user nagios@localhost in the database?<br><div><div><div><div><br></div><div>Lewis</div><div><br></div><div>On May 4, 2011, at 3:16 PM, The Sinner wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">hi all,<div><br></div><div>i receive <b>access denied for user 'nagios'@'localhost' (using password no)</b> error.</div><div><br></div><div>what i did so far:</div><div><br></div><div>logged in to mysql and selected mysql database then:</div> <div>> grant all privileges on *.* to 'nagios'@'localhost' identified by 'mypass';</div></blockquote><blockquote type="cite"><div>> flush privileges;</div><div><br></div><div>then wrote a service to run the check_mysql command.</div> <div><br></div><div>the service is like:</div><div><br></div><div>...</div><div>... <b>check_mysql!-H localhost -d mysql -u nagios -p mypass</b></div><div>...<br clear="all"><br></div><div>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?</div> <div><br></div><div>thanks in advance.</div><div><br>-- <br>The Sinner<br> </div> ------------------------------------------------------------------------------<br>WhatsUp Gold - Download Free Network Management Software<br>The most intuitive, comprehensive, and cost-effective network <br>management toolset available today. Delivers lowest initial <br>acquisition cost and overall TCO of any competing solution.<br><a href="http://p.sf.net/sfu/whatsupgold-sd_______________________________________________">http://p.sf.net/sfu/whatsupgold-sd_______________________________________________</a><br>Nagiosplug-help mailing list<br>Nagiosplug-help@lists.sourceforge.net<br>https://lists.sourceforge.net/lists/listinfo/nagiosplug-help<br>::: Please include plugins version (-v) and OS when reporting any issue. <br>::: Messages without supporting info will risk being sent to /dev/null<br></blockquote></div><br></div></div></body></html>