Re: MySQL Router - Windows 8.0.30 - Fails at boottrapping creation - Router configuration files
Posted by: Jose Ramirez
Date: December 15, 2022 10:27AM

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

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.