Re: MySQL Router - Windows 8.0.30 - Fails at boottrapping creation - Router configuration files

[Jose Ramirez]

Hello Edwin,
the default_authentication_plugin variable was deprecated starting server 8.0.27, now authentication_policy should be used. Please remove default_authentication_plugin from your ini file and optionally add authentication_policy=*,,. If you don't add it the default value will be used when starting the server. See the following link for details: https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_authentication_policy

Having said that, these variables only determine the authentication plugin being assigned to new users. Since your users where originally created with the mysql_native_password plugin that is why you get those results. To change the authentication plugin for existing users refer to the following documentation: https://dev.mysql.com/doc/refman/8.0/en/alter-user.html


====================================
Jose Ramirez
MySQL on Windows Team