NetXMS Support Forum

Hello,

Thanks for your help. Your driver did not work on my MySQL.

But the solution: https://stackoverflow.com/questions/49194719/authentication-plugin-caching-sha2-password-cannot-be-loaded
almost worked for me.

Their technique of modifying my.ini (on Windows) blocked the restart of my server.

The real solution that worked for me on Windows Server 2019 was to uninstall and then reinstall the MySQL 8.0.21 server, this time changing the encryption of the password during the installtion.

As well as creating the database myself and the user because the automatic version of NetXMS does not work.

Thanks for the help, good bey.

Hello,

I have a problem that prevents me from installing NetXMS 3.4.313 x64 server on Windows Server 2019.

My problem is for the connection to the database when installing the NetXMS server.

I have already tested the 2 possibilities of either letting the installer create the database or having already created it myself with a user created especially for this database.

I also tried the basic login credentials "admin" with the password "netxms" although they shouldn't be the ones that should be used at this point in the installation.

In both cases I have the same error which comes to me.

I have already researched the "caching_sha2_password" error and could not find a solution to fix this bug.

In the administrator's guide it is noted that the compatibility with the MySQL 8.0 server is taken into account.
I tried to install an old version of MySQL Server, 5.7 for example, but it still doesn't work.

If you have a solution it is welcome and thank you in advance for your help.