Error
Error Code:
1275
MySQL Error 1275: Incompatible Password Format
Description
This error occurs when a MySQL server configured with `--secure-auth` enabled rejects a connection attempt because the authenticating user account has a password stored in an old, insecure format. It signifies a mismatch between the server's security requirements and the user's password hash type, preventing successful authentication.
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 Enabled
The MySQL server instance is explicitly configured to require secure authentication methods, rejecting older, less secure password formats for enhanced security.
Legacy User Account
The specific MySQL user account attempting to connect has its password hashed using a format that predates MySQL 4.1, which is incompatible with the server's secure-auth mode.
Migration Without Password Update
User accounts were migrated from an older MySQL server to a newer one with secure-auth enabled, but their passwords were not updated to the modern hashing 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