Bug #89573 default_authentication_plugin should be dynamic

• Submitted: 7 Feb 2018 16:00
• Modified: 8 Sep 2021 12:56
• Reporter: Daniël van Eeden (OCA)
• Status: Closed
• Category: MySQL Server: Pluggable Authentication
• Severity: S4 (Feature request)
• Version: 8.0.4
• OS: Any
• CPU Architecture: Any
• Tags: dynamic

[7 Feb 2018 16:00] Daniël van Eeden

Description:
Having to restart to change default_authentication_plugin makes changing this more difficult than it should

How to repeat:
mysql> SET GLOBAL default_authentication_plugin='mysql_native_password';
ERROR 1238 (HY000): Variable 'default_authentication_plugin' is a read only variable

[7 Feb 2018 16:04] Daniël van Eeden

changed category

[8 Feb 2018 14:27] MySQL Verification Team

Hello Daniël,

Thank you for the feature request!

Thanks,
Umesh

[7 Mar 2018 16:38] Daniël van Eeden

Marking Bug #89945 as a duplicate of this bug

[2 Aug 2021 12:46] Georgi Kodinov

Posted by developer:
 
Implemented by WL#14183 introducing a dynamic variable authentication_policy that deprecates  default_authentication_plugin.

[8 Sep 2021 12:56] Daniel Price

Posted by developer:
 
Fixed as of the upcoming 8.0.27 release:

The default_authentication_plugin variable is deprecated as of MySQL
8.0.27; expect support for it to be removed in a future version of MySQL.

The default_authentication_plugin variable is still used in
MySQL 8.0.27, but in conjunction with and at a lower precedence than the
new authentication_policy system variable, which is introduced in MySQL
8.0.27 with the multifactor authentication feature.