[prev in list] [next in list] [prev in thread] [next in thread]
List: nagios-users
Subject: [Nagios-users] R: I: R: R: configuration tool
From: "Marco Borsani" <m.borsani () it ! net>
Date: 2011-11-18 9:11:27
Message-ID: 007601cca5d2$13b891c0$3b29b540$ () it ! net
[Download RAW message or body]
I am connecting as root .. also using a tool like TOAD.
But I still can't perform any admin tasks remotely (via command line or web tool).
MySQL> Select user,host,password from user;
+------+------------------+--------------------------------------------------------------+
| user | host | password \
| +------+------------------+--------------------------------------------------------------+
| root | localhost | *FAA8329A4686D5A4F44ECEA789A1BF7B76373F5E |
> root | <hostname> | *FAA8329A4686D5A4F44ECEA789A1BF7B76373F5E |
> root | 127.0.0.1 | *FAA8329A4686D5A4F44ECEA789A1BF7B76373F5E |
> > localhost | \
> > |
> > <hostname> | \
> > |
> root | <ip-address-naigosserver> | *FAA8329A4686D5A4F44ECEA789A1BF7B76373F5E |
> root | <ip-address-mysqlserver> | *FAA8329A4686D5A4F44ECEA789A1BF7B76373F5E |
> root | % | *FAA8329A4686D5A4F44ECEA789A1BF7B76373F5E |
+------+------------------+--------------------------------------------------------------+ \
Thanks
Marco
-----Messaggio originale-----
Da: Giorgio Zarrelli [mailto:zarrelli@linux.it]
Inviato: giovedì 17 novembre 2011 22:02
A: Nagios Users List
Cc: NAGIOS
Oggetto: Re: [Nagios-users] I: R: R: configuration tool
So, you are not Connecting as root from nagiosql
Please paste here The nagiosql install screenshot and The result of
use mysql ;
Select user,host,password from user;
Ciao,
Giorgio
Il giorno 17/nov/2011, alle ore 16:45, "Marco Borsani" <m.borsani@it.net> ha scritto:
> Nothing happen, I still have same problem.
>
> Marco
>
> -----Messaggio originale-----
> Da: Giorgio Zarrelli [mailto:zarrelli@linux.it]
> Inviato: gioved 17 novembre 2011 14:39
> A: Marco Borsani
> Cc: 'Giorgio Zarrelli'; 'Nagios Users List'
> Oggetto: Re: R: R: [Nagios-users] configuration tool
>
> Hi,
>
> > MySQL> grant all on mysql.* to root@'<ip-nagiosserver>' identified by
> > 'password';
>
> Try
>
> MySQL> grant all on *.* to root@% identified by 'password';
>
> It will allow connection as root from ANY host/hostname and will give ALL \
> privileges on ALL databases.
> As I told before: REMOVE this user as soon as you complete NagioSQL installation.
>
>
> ----------------------------------------------------------------------
> -------- All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Nagios-users mailing list
> Nagios-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/nagios-users
> > > > Please include Nagios version, plugin version (-v) and OS when reporting any \
> > > > issue.
> > > > Messages without supporting info will risk being sent to /dev/null
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a definitive \
record of customers, application performance, security threats, fraudulent activity, \
and more. Splunk takes this data and makes sense of it. IT sense. And common sense. \
http://p.sf.net/sfu/splunk-novd2d _______________________________________________
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
> > > Please include Nagios version, plugin version (-v) and OS when reporting any \
> > > issue.
> > > Messages without supporting info will risk being sent to /dev/null
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Nagios-users mailing list
Nagios-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
> > > Please include Nagios version, plugin version (-v) and OS when reporting any \
> > > issue.
> > > Messages without supporting info will risk being sent to /dev/null
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic