Nagios Support Forum

This document might have some helpful information as well: http://exchange.nagios.org/directory/Documentation/Nagios-XI-Documentation/Database-Access-For-Development-Purposes/details This document helped tremendously. I followed the section required to create a user and open firewall. I can now acc...

The reset article worked great and I got the root user password reset in MySQL.

Now I ran the commands for remote access in the original article and they were accepted. Now I still get the first message I posted about.

See attached.

I tried to log in as Root to MySQL but get this -

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

So why is that and how do I get around it?

Thanks Brian.

What user do I use to run the UPDATE commands? The user nagiosql does not have the update permission.

Here is the output from each command - mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | nagiosql | | test | +--------------------+ mysql> use nagiosql Reading table information for completion of table and column names You can turn off this fe...

Here is the command that I am running and error - mysql> update db set Host='X.X.X.X' where Db='nagiosql'; ERROR 1046 (3D000): No database selected If I then select the database 'nagiosql' I then get error - mysql> update db set Host='X.X.X.X' where Db='nagiosql'; ERROR 1146 (42S02): Table 'nagiosql...

At Step #5 of granting access to my laptop IP and get the following error -

ERROR 1146 (42S02) : Table 'nagiosql.db' doesn't exist

How do I get around this?

How do I access the MySQL database remotely? Is there commands to allow remote connections from applications like SQLyog? I have all credentials but when testing connections get error 2003 - Can't connect to MySQL serer on IP address (0) I need to pull data that the Web interface does not allow me t...