Hello everyone -
I have Nagios checks set up on a MySQL Replication slave. These checks have been working just fine for two years.
Suddenly this morning, we are seeing errors indicating:
"Access denied for user nagios@10.##.##.##"
The nagios user exists in the MySQL server as nagios@locahost
So, the 'quick-fix' is to add the MySQL account nagios@10.##.##.## - but - I have been asked to find out what actually happened here.
I am unable to find any DNS errors in the MySQL error log (as I have seen on other occasions on other servers in the past).
The /etc/hosts file does NOT have an entry associating the IP address with localhost
/var/log/messages also contains no DNS messages.
Has anyone ever seen this before?
I performed some searches here and on Google, but I'm not finding much that exists out there about this -
Thanks in advance for any ideas you might be able to send my way.