R: I: R: R: configuration tool

[Marco Borsani]

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 at 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 at it.net> ha scritto:

> Nothing happen, I still have same problem.
> 
> Marco
> 
> -----Messaggio originale-----
> Da: Giorgio Zarrelli [mailto:zarrelli at 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 at 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 at 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 at 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