NetXMS Support Forum

Hello,

I have setup netxms-2.2.2 on MS server 2008 R2 with MySQL. The DB config in the installer worked as expected but after the installer the core service would not start. Results for nxdbmgr check show "Unable to connect to database netxms3@localhost as netxms: Access denied for user 'netxms'@'localhost' (using password: YES)". I issued in MySQL command line "GRANT ALL PRIVILEGES ON netxms3.* TO 'netxms'@'localhost';" (same as suggestion here https://www.netxms.org/forum/configuration/not-able-to-connect-database/). I flushed the perms and recycled MySQL but still getting the same error for nxdbmgr check "Unable to connect to database netxms3@localhost as netxms: Access denied for user 'netxms'@'localhost' (using password: YES)". Would you have any suggestions on other steps to try?

Output from show grants:
mysql> show grants for 'netxms'@'localhost';
+-------------------------------------------------------------+
| Grants for netxms@localhost                                 |
+-------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'netxms'@'localhost'         |
| GRANT ALL PRIVILEGES ON `netxms2`.* TO 'netxms'@'localhost' |
| GRANT ALL PRIVILEGES ON `netxms3`.* TO 'netxms'@'localhost' |
| GRANT ALL PRIVILEGES ON `mysql`.* TO 'netxms'@'localhost'   |
| GRANT ALL PRIVILEGES ON `sys`.* TO 'netxms'@'localhost'     |
| GRANT ALL PRIVILEGES ON `netxms`.* TO 'netxms'@'localhost'  |
+-------------------------------------------------------------+

Thanks!
Brian