Error
Error Code:
4058
MySQL Error 4058: Authentication Policy Mismatch
Description
This error indicates that the authentication method being used for a user or connection attempt does not comply with the MySQL server's configured `authentication_policy`. It typically occurs when a user's authentication plugin or method violates the rules defined by the `@@authentication_policy` system variable.
Error Message
%d factor authentication method does not match against authentication policy. Please refer @@authentication_policy system variable.
Known Causes
4 known causesMismatched User Plugin
The authentication plugin configured for the connecting user account does not meet the requirements specified by the active `authentication_policy`.
Policy Update Conflict
The global `authentication_policy` was updated to a stricter setting after a user was created, making existing user configurations non-compliant.
Incompatible User Creation
An attempt was made to create a new user with an authentication method that is not permitted by the current `authentication_policy`.
Disallowed Legacy Method
A legacy or weak authentication method is being used for a user account, which is explicitly disallowed by the current `authentication_policy` settings.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service