Bug #108622 Mysql 8.xx Windows (10/11) change default authentication plugin setting ..

• Submitted: 27 Sep 2022 11:28
• Modified: 27 Sep 2022 12:50
• Reporter: André verwijs
• Status: Unsupported
• Category: MySQL Server: Pluggable Authentication
• Severity: S3 (Non-critical)
• OS: Windows (10/11)
• CPU Architecture: Any

[27 Sep 2022 11:28] André verwijs

Description:
MySQL 8.xx Windows (10/11) - my.ini 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  
change default authentication plugin setting from "authentication_policy=mysql_native_password,," to "default-authentication-plugin=mysql_native_password" 
 
"authentication policy" is not compatible with older software 
and C# source code (which uses MySQL connection)  

thanks

How to repeat:
- install Mysql 8.xx on Windows 
- run with software that use mysql connection or source code project

[27 Sep 2022 12:50] MySQL Verification Team

Hi Mr. verwijs,

Thank you for your bug report.

However, we can not and we will not change our default authentication policy in 8.0.

Simply, we have decided that, since 8.0, we shall increase security of our server in every single respect. Hence, we  adopted a policy that gives results by relying on the highly encrypted password protection.

However, every of our Connectors and  API's  can always use the original password authentication, by adopting a different algorithm. 

There are many ways in which to achieve them, all of which are properly documented in our Reference Manual.

Unsupported.