Comments - Maxscale 2.2.21 + mysql 8.0.32 auth failed
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
The authentication is more decided by the account plugin rather than the system variable.
authentication_policy is dynamic in MySQL-8.0 and has a higher precidence thatn default_authentication _plugin
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_authentication_policy
In the case of authentication_policy, it is " * " . In this case, doesn't this mean it is allowed under all policies? To follow the account plugin, in our account, it is mysql_native_password. authenticator=MySQLBackendAuth and protocol=MySQLBackend In the case of the Mysqlbackend protocol, mysql_native_password is supported, so I thought there would be no problem. Can you tell me what the problem is?