Access denied for user 'apache'@'localhost' (using password:

Support forum for Nagios Core, Nagios Plugins, NCPA, NRPE, NSCA, NDOUtils and more. Engage with the community of users including those using the open source solutions.
Locked
Ingmar79
Posts: 8
Joined: Thu Apr 07, 2011 5:39 am

Access denied for user 'apache'@'localhost' (using password:

Post by Ingmar79 »

Hello,

First of all sorry for bothering anyone here for this question. It's a stupid one :-) I accidently changed the
sql_user password, so when I click on nagios QL, I get a message saying:

SELECT `category`,`name`,`value` FROM `tbl_settings`Error[3]: Access denied for user 'apache'@'localhost' (using password: NO)

I understand I need to change the MySQL password to the table it wants to view. But where can I change the sql_user pw in Nagios?
Ingmar79
Posts: 8
Joined: Thu Apr 07, 2011 5:39 am

Re: Access denied for user 'apache'@'localhost' (using passw

Post by Ingmar79 »

Already solved this by changing the mysql user: nagiosql_user back to it's old password. All is fine again :)
rdedon
Posts: 578
Joined: Sat Nov 20, 2010 4:51 pm

Re: Access denied for user 'apache'@'localhost' (using passw

Post by rdedon »

Excellent! We had just approved this and were going to respond :-)
Rene deDon
Technical Team
___
Nagios Enterprises, LLC
Web: http://www.nagios.com
Locked