Nagios Support Forum

That's strange that you can't run the MySQL command. You're saying the password for the nagiosxi MySQL user was never changed?

yes, we never login as nagiosxi, login as root. I"m check my database right now and user nagiosxi is not even there.

[root@MA100DLVM scripts]#mysql -uroot -pnagiosxi
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25237
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| nagios |
| nagiosql |
| test |
+--------------------+
5 rows in set (0.00 sec)

mysql> select user for mysql.user;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql.user' at line 1
mysql> select user from mysql.user;
+----------+
| user |
+----------+
| root |
| |
| nagiosql |
| ndoutils |
| root |
| |
| root |
+----------+
8 rows in set (0.00 sec)

Are both of your threads for the same issue?

we're able to get this work. thanks

Thanks for that update, we'll lock this thread now.