NetXMS Support Forum

I'm trying to install NetXMS on Windows Server 2019 and using MySQL version 8. I try to create the database at installation but I get the following error. I'm new to MySQL so I'm not sure what to do.

thanks for any help

The reason could be that caching_sha2_password, let me cite a paragraph from the docs:

Bundled MySQL database drive does not support caching_sha2_password authentication which is default for MySQL starting from version 8.  Either select Legacy Authentication Method  when  installing  MySQL,  or  use  database  driver  installed  along  with  MySQL.  Databasedriver gets installed when installing MySQL with Server-only option,  however these two folders should be included into system path:C:\Program Files\MySQL\MySQL Server 8.0\lib C:\Program Files\MySQL\MySQL Server 8.0\bin.

Thank you for your reply. I did select legacy authentication when installing MySQL

Hi,

this is bug NX-1964: https://track.radensolutions.com/issue/NX-1964. It is fixed in development branch, but not in version 3.8. In the meantime, create user and database manually and choose to initialize existing database in installation wizard.

Best regards,
Victor