Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
If more than one authentication mechanism is declared using the OR keyword, the mechanisms are attempted in the order they are declared in the CREATE USER statement. As soon as one of the authentication mechanisms is successful, authentication is complete.
This leads to an unoptimal situation (assuming user account uses authenticators A and B in that order): Client gives password for authenticator B and asks for B in handshake response, yet server tries authenticator A first. Only once it fails, does the server switch to B.
Server could try B first, assuming plugin B is loaded and the user account uses it.
Attachments
Issue Links
- is blocked by
-
MDEV-12320 configurable default authentication plugin for the server
-
- Stalled
-