upgrading nagiosxi xi issue

[hsmith]

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

[amit.ahuja]

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)

[hsmith]

Are both of your threads for the same issue?

[amit.ahuja]

we're able to get this work. thanks

[bwallace]

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