<div class="gmail_quote">On Wed, May 20, 2009 at 12:36 PM, David Gossage <<a href="mailto:dgossage@zacks.com">dgossage@zacks.com</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <div> Access denied for user 'nagios'@'<a href="http://qeren.zacks.com" target="_blank">qeren.zacks.com</a>' (using password: YES) And oddly it's the opposite for the original server which works in nagios, but returns same error on commandline. Here is what the current permissions are set to which is the same as on the original server as far as I can tell. User:nagios Host:<a href="http://server.domain.com" target="_blank">server.domain.com</a> Password:Yes GlobalPrivileges:<tt>U</tt>SAGE<tt> Grant:No</tt> </div></blockquote></div> Each MySQL server needs to be told to allow nagios (or whatever the checking username is) from the host doing the checking. I don't know if you changed the output pasted above, but where the error message says 'nagios'@'<a href="http://qeren.zacks.com/" target="_blank">qeren.zacks.com</a>', the output you pasted at "current permissions are set to which is the same as on the original server " says login permissions are granted to 'nagios'@'<a href="http://server.domain.com">server.domain.com</a>'. The host just needs to match the Nagios server's name, as seen by the MySQL server. Or it can be an IP address. If your Nagios server is <a href="http://queren.zacks.com">queren.zacks.com</a>, then each individual MySQL server needs to allow 'nagios' to log in from '<a href="http://qeren.zacks.com">qeren.zacks.com</a>'. You'd enable it by running a grant statement such as this, within MySQL, on each server: GRANT SELECT ON *.* TO 'nagios'@'<a href="http://qeren.zacks.com/" target="_blank">qeren.zacks.com</a>' IDENTIFIED BY PASSWORD 'plaintextpassword'; Grant and add user syntax are at: <a href="http://dev.mysql.com/doc/refman/5.1/en/create-user.html">http://dev.mysql.com/doc/refman/5.1/en/create-user.html</a> -Mike