MySQL Error number: MY-010317; Symbol: ER_AUTHCACHE_USER_IGNORED_DEPRECATED_PASSWORD; SQLSTATE: HY000 报错 故障修复 远程处理

文档解释

Error number: MY-010317; Symbol: ER_AUTHCACHE_USER_IGNORED_DEPRECATED_PASSWORD; SQLSTATE: HY000

Message: User entry ‘%s’@’%s’ has a deprecated pre-4.1 password. The user will be ignored and no one can login with this user anymore.

错误说明:

MY-010317 ER_AUTHCACHE_USER_IGNORED_DEPRECATED_PASSWORD (HY000) is a MySQL error that occurs when the server has attempted to authenticate a user supplied a deprecated password. This error can be generated when attempting to use an old password, set pre-MySQL 8.0, that uses a deprecated password hashing algorithm.

常见案例

MY-010317 ER_AUTHCACHE_USER_IGNORED_DEPRECATED_PASSWORD (HY000) is a common error when attempting to upgrade from a pre-MySQL 8.0 version. This can occur when the server is set up with an old password hashing algorithm, as the deprecated algorithms are not supported in MySQL 8.0 and later.

解决方法：

This error can be fixed by resetting the password authentication process for the affected user to use the new authentication algorithms that are supported in MySQL 8.0 and later. This can be done through the ALTER USER statement, which allows the user to reset their password, as well as update a different authentication type (e.g. caching_sha2_password or sha256_password). Once the updated authentication method is specified, the user should be able to authenticate as usual with their new password.