NetXMS Forum

Yes, of course, every time, I even manualy made netxms_db schema from NetXMS mysql template, but the problem is with rights, NetXMS cannot login to MySQL for some reason... I can't figure it out why...
Today I tried to install on Windows Server 2019, and got totally the same result...

Here is the part of a log file:

2023.08.20 19:17:30.947 *I* [logger            ] Log file opened (rotation policy 2, max size 16777216)
2023.08.20 19:17:30.947 *I* [startup            ] Starting NetXMS server version 4.4.1 build tag 4.4-474-g124dcc0f7d
2023.08.20 19:17:30.948 *I* [logger            ] Debug level set to 0
2023.08.20 19:17:30.948 *I* [config            ] Main configuration file: C:\NetXMS\etc\netxmsd.conf
2023.08.20 19:17:30.948 *I* [config            ] Configuration tree:
2023.08.20 19:17:30.948 *I* [config            ] config
2023.08.20 19:17:30.948 *I* [config            ]  +- server
2023.08.20 19:17:30.948 *I* [config            ]      +- DBDriver
2023.08.20 19:17:30.948 *I* [config            ]      |    value: mysql.ddr
2023.08.20 19:17:30.948 *I* [config            ]      +- DBServer
2023.08.20 19:17:30.948 *I* [config            ]      |    value: localhost
2023.08.20 19:17:30.948 *I* [config            ]      +- DBName
2023.08.20 19:17:30.948 *I* [config            ]      |    value: netxms_db
2023.08.20 19:17:30.948 *I* [config            ]      +- DBLogin
2023.08.20 19:17:30.948 *I* [config            ]      |    value: root
2023.08.20 19:17:30.948 *I* [config            ]      +- DBPassword
2023.08.20 19:17:30.948 *I* [config            ]      |    value: ********
2023.08.20 19:17:30.948 *I* [config            ]      +- LogFile
2023.08.20 19:17:30.948 *I* [config            ]          value: C:\NetXMS\log\netxmsd.log
2023.08.20 19:17:30.966 *I* [db.drv            ] Database driver "mysql.ddr" loaded and initialized successfully
2023.08.20 19:17:30.971 *I* [comm.listener      ] SocketListener/LocalAdmin: listening on 127.0.0.1:21784
2023.08.20 19:17:30.971 *I* [comm.listener      ] SocketListener/LocalAdmin: listening on [127.0.0.1]:21784
2023.08.20 19:17:56.009 *E* [db                ] Unable to establish connection with database (Authentication plugin 'caching_sha2_password' cannot be loaded: The specified module could not be found.)

2023.08.20 19:31:56.000 *I* [logger            ] Log file opened (rotation policy 2, max size 16777216)
2023.08.20 19:31:56.000 *I* [startup            ] Starting NetXMS server version 4.4.1 build tag 4.4-474-g124dcc0f7d
2023.08.20 19:31:56.000 *I* [logger            ] Debug level set to 0
2023.08.20 19:31:56.001 *I* [config            ] Main configuration file: C:\NetXMS\etc\netxmsd.conf
2023.08.20 19:31:56.001 *I* [config            ] Configuration tree:
2023.08.20 19:31:56.001 *I* [config            ] config
2023.08.20 19:31:56.001 *I* [config            ]  +- server
2023.08.20 19:31:56.001 *I* [config            ]      +- DBDriver
2023.08.20 19:31:56.001 *I* [config            ]      |    value: mysql.ddr
2023.08.20 19:31:56.001 *I* [config            ]      +- DBServer
2023.08.20 19:31:56.001 *I* [config            ]      |    value: localhost
2023.08.20 19:31:56.001 *I* [config            ]      +- DBName
2023.08.20 19:31:56.001 *I* [config            ]      |    value: netxms_db
2023.08.20 19:31:56.001 *I* [config            ]      +- DBLogin
2023.08.20 19:31:56.001 *I* [config            ]      |    value: admin
2023.08.20 19:31:56.001 *I* [config            ]      +- DBPassword
2023.08.20 19:31:56.001 *I* [config            ]      |    value: ********
2023.08.20 19:31:56.001 *I* [config            ]      +- LogFile
2023.08.20 19:31:56.001 *I* [config            ]          value: C:\NetXMS\log\netxmsd.log
2023.08.20 19:31:56.021 *I* [db.drv            ] Database driver "mysql.ddr" loaded and initialized successfully
2023.08.20 19:31:56.022 *I* [comm.listener      ] SocketListener/LocalAdmin: listening on 127.0.0.1:21784
2023.08.20 19:31:56.022 *I* [comm.listener      ] SocketListener/LocalAdmin: listening on [127.0.0.1]:21784
2023.08.20 19:32:21.056 *E* [db                ] Unable to establish connection with database (Access denied for user 'admin'@'%' to database 'netxms_db')

2023.08.20 19:43:49.985 *I* [logger            ] Log file opened (rotation policy 2, max size 16777216)
2023.08.20 19:43:49.985 *I* [startup            ] Starting NetXMS server version 4.4.1 build tag 4.4-474-g124dcc0f7d
2023.08.20 19:43:49.985 *I* [logger            ] Debug level set to 0
2023.08.20 19:43:49.985 *I* [config            ] Main configuration file: C:\NetXMS\etc\netxmsd.conf
2023.08.20 19:43:49.985 *I* [config            ] Configuration tree:
2023.08.20 19:43:49.985 *I* [config            ] config
2023.08.20 19:43:49.986 *I* [config            ]  +- server
2023.08.20 19:43:49.986 *I* [config            ]      +- DBDriver
2023.08.20 19:43:49.986 *I* [config            ]      |    value: mysql.ddr
2023.08.20 19:43:49.986 *I* [config            ]      +- DBServer
2023.08.20 19:43:49.986 *I* [config            ]      |    value: localhost
2023.08.20 19:43:49.986 *I* [config            ]      +- DBName
2023.08.20 19:43:49.986 *I* [config            ]      |    value: netxms_db
2023.08.20 19:43:49.986 *I* [config            ]      +- DBLogin
2023.08.20 19:43:49.986 *I* [config            ]      |    value: admin
2023.08.20 19:43:49.986 *I* [config            ]      +- DBPassword
2023.08.20 19:43:49.986 *I* [config            ]      |    value: ********
2023.08.20 19:43:49.986 *I* [config            ]      +- LogFile
2023.08.20 19:43:49.986 *I* [config            ]          value: C:\NetXMS\log\netxmsd.log
2023.08.20 19:43:49.998 *I* [db.drv            ] Database driver "mysql.ddr" loaded and initialized successfully
2023.08.20 19:43:49.998 *I* [comm.listener      ] SocketListener/LocalAdmin: listening on 127.0.0.1:21784
2023.08.20 19:43:49.998 *I* [comm.listener      ] SocketListener/LocalAdmin: listening on [127.0.0.1]:21784
2023.08.20 19:44:15.059 *E* [db                ] Unable to establish connection with database (Access denied for user 'admin'@'localhost' to database 'netxms_db')

I tried to install NetXMS latest version  4.4.1 on Windows 10 with MySQL80 several times, and every time it cannot connect to the database server, no matter what username/password combination I used (tried also to change authentication method to legacy password). In addition to that, I cannot login to the NetXMS server for the first time, no matter what client I use - new webUI, jar or legacy web, I always get message "Connection refused"...
I thought it is just run-and-use operation, but for me it's mission impossible... Where'm I wrong???