ShokoAnime
MySQL version 8.0.4 and above authentication - "caching_sha2_password"
VERSION INFORMATION
Server Version: Latest Daily - 25/04/2018
Desktop Version: Latest Daily - 20/04/2018
LOG FILE
DESCRIPTION
It would appear that there is now a new default authentication method in MySQL Server that ShokoServer does not support.
https://mysqlserverteam.com/mysql-8-0-4-new-default-authentication-plugin-caching_sha2_password/
It is possible to select legacy upon server install though not ideal.
At the least, I have no intention of supporting additional auth methods for SQL, else I would enable Windows user auth for SQL Server. It's a lot of work. It's worth noting in the docs, I suppose, that this issue can occur.
from mysql-docs:
For the server, the default value of the default_authentication_plugin system variable changes from mysql_native_password to caching_sha2_password.
This change applies only to new accounts created after installing or upgrading to MySQL 8.0.4 or later. For accounts already existing in an upgraded installation, their authentication plugin remains unchanged.
So any new account create on new installation will use caching_sha2_password by default. We use NHibernate for this, so its not our problem right now.
We are planning to deprecate mysql anyways I see no point in investing time into this.
That plan is one that has been long on the works, this will likely be fixed in .net core/EF refactor etc.
On Sun, Jun 3, 2018, 2:08 AM hidden4003 [email protected] wrote:
We are planning to deprecate mysql anyways I see no point in investing time into this.
— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ShokoAnime/ShokoServer/issues/732#issuecomment-394097978, or mute the thread https://github.com/notifications/unsubscribe-auth/AA8rpniPf-C7bdQdwlLGGMjIqJFf69LVks5t4riKgaJpZM4TqVSo .
