SQL query failed during installation
-
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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login