Error
Error Code:
1275
MariaDB Error 1275: Old Password Format in Secure Auth
Description
This error indicates that your MariaDB server is running in a secure authentication mode, which requires passwords to be stored in a modern, more secure format. It occurs when a user attempts to connect using a password that was created using an older, less secure hashing algorithm, which is incompatible with the server's current security settings.
Error Message
Server is running in --secure-auth mode, but '%s'@'%s' has a password in the old format; please change the password to the new format
Known Causes
3 known causesServer Secure Auth Mode Enabled
The MariaDB server is configured to require modern password hashing algorithms, often enforced by the `--secure-auth` option or similar security policies.
User Account with Outdated Password
The specific user account attempting to connect has a password stored in an older, less secure format that is incompatible with the server's secure authentication requirements.
Migration from Legacy System
This error can arise after migrating a database or user accounts from an older MySQL or MariaDB version where passwords might have been created and stored in a deprecated format.
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