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:zarre...@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.bors...@it.net> ha
scritto:
> Nothing happen, I still have same problem.
>
> Marco
>
> -----Messaggio originale-----
> Da: Giorgio Zarrelli [mailto:zarre...@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
