MySQL Error number: MY-013294; Symbol: ER_WARNING_RETAIN_CURRENT_PASSWORD_CLAUSE_VOID; SQLSTATE: HY0

2023-11-05 18:06

短信预约 -IT技能 免费直播动态提醒

文档解释

Error number: MY-013294; Symbol: ER_WARNING_RETAIN_CURRENT_PASSWORD_CLAUSE_VOID; SQLSTATE: HY000

Message: RETAIN CURRENT PASSWORD ignored for user ‘%s’@’%s’ as its authentication plugin %s does not support multiple passwords.

错误说明：

ER_WARNING_RETAIN_CURRENT_PASSWORD_CLAUSE_VOID错误指的是在执行ALTER USER语句时，如果使用了 RETAIN CURRENT PASSWORD 子句，那么在使用MySQL 8.0版本或更高版本时会引发这个错误。

常见案例

ER_WARNING_RETAIN_CURRENT_PASSWORD_CLAUSE_VOID错误常见于在MySQL 8.0版本及以上使用ALTER USER语句时，并且在这个语句中带有RETAIN CURRENT PASSWORD子句时出现。

解决方法：

首先，我们需要确认MySQL服务器是否已经运行在MySQL 8.0版本或更高版本。如果是，那么我们可以尝试将ALTER USER语句中的RETAIN CURRENT PASSWORD子句删除。另外，我们也可以尝试将ALTER USER语句的“IDENTIFIED BY ‘newpassword’”子句替换为“IDENTIFIED WITH[哈希算法] BY ‘newpassword’”。

免责声明：

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

报错故障 number

阅读原文内容投诉

MySQL Error number: MY-013294; Symbol: ER_WARNING_RETAIN_CURRENT_PASSWORD_CLAUSE_VOID; SQLSTATE: HY0

下载Word文档到电脑，方便收藏和打印～

下载Word文档

MySQL Error number: MY-013294; Symbol: ER_WARNING_RETAIN_CURRENT_PASSWORD_CLAUSE_VOID; SQLSTATE: HY0

文档解释

常见案例

MySQL Error number: MY-013294; Symbol: ER_WARNING_RETAIN_CURRENT_PASSWORD_CLAUSE_VOID; SQLSTATE: HY0

相关文章

猜你喜欢

MySQL Error number: MY-013294; Symbol: ER_WARNING_RETAIN_CURRENT_PASSWORD_CLAUSE_VOID; SQLSTATE: HY0

MySQL Error number: MY-011682; Symbol: ER_GRP_RPL_SLAVE_PRESERVE_COMMIT_ORDER_NOT_SET; SQLSTATE: HY0

MySQL Error number: MY-011692; Symbol: ER_GRP_RPL_SUPPORTS_ONLY_ONE_FORCE_MEMBERS_SET; SQLSTATE: HY0

MySQL Error number: MY-013240; Symbol: ER_SHARED_TABLESPACE_USED_BY_PARTITIONED_TABLE; SQLSTATE: HY0

MySQL Error number: MY-011411; Symbol: ER_KEYRING_ENCRYPTED_FILE_PASSWORD_IS_TOO_LONG; SQLSTATE: HY0

MySQL Error number: MY-011599; Symbol: ER_GRP_RPL_CANNOT_EXECUTE_TRANS_WHILE_STOPPING; SQLSTATE: HY0

MySQL Error number: MY-011247; Symbol: ER_SHA_PWD_FAILED_TO_GENERATE_MULTI_ROUND_HASH; SQLSTATE: HY0

MySQL Error number: MY-011704; Symbol: ER_GRP_RPL_SQL_SERVICE_FAILED_TO_RUN_SQL_QUERY; SQLSTATE: HY0

MySQL Error number: MY-010419; Symbol: ER_RPL_ERROR_CHANGING_RELAY_LOG_INFO_REPO_TYPE; SQLSTATE: HY0

MySQL Error number: MY-011358; Symbol: ER_KEYRING_CHECK_KEY_FAILED_DUE_TO_INVALID_KEY; SQLSTATE: HY0

MySQL Error number: MY-011219; Symbol: ER_AUDIT_LOG_FILTER_FAILED_TO_STORE_TABLE_FLDS; SQLSTATE: HY0

MySQL Error number: MY-011435; Symbol: ER_KEYRING_AWS_FAILED_TO_FLUSH_KEYRING_TO_FILE; SQLSTATE: HY0

MySQL Error number: MY-013749; Symbol: ER_GRP_RPL_VIEW_CHANGE_UUID_SAME_AS_GROUP_NAME; SQLSTATE: HY0

MySQL Error number: MY-011637; Symbol: ER_GRP_RPL_FAILED_TO_INIT_COMMUNICATION_ENGINE; SQLSTATE: HY0

MySQL Error number: MY-013877; Symbol: ER_IB_MSG_LOG_UPGRADE_FLUSH_FAILED__UNEXPECTED; SQLSTATE: HY0

MySQL Error number: MY-010564; Symbol: ER_RPL_SLAVE_IO_THREAD_CANT_REGISTER_ON_MASTER; SQLSTATE: HY0

MySQL Error number: MY-013282; Symbol: ER_SERVER_RPL_ENCRYPTION_FAILED_TO_ROTATE_LOGS; SQLSTATE: HY0

MySQL Error number: MY-013737; Symbol: ER_GRP_RPL_MEMBER_ACTION_DEFAULT_CONFIGURATION; SQLSTATE: HY0

MySQL Error number: MY-013523; Symbol: ER_TABLE_NAME_IN_UPPER_CASE_NOT_ALLOWED_FOR_FK; SQLSTATE: HY0

MySQL Error number: MY-013659; Symbol: ER_GRP_RPL_TIMEOUT_RECEIVED_VC_LEAVE_ON_REJOIN; SQLSTATE: HY0

热门标签

编程热搜

编程资源站

目录

感谢您的提交，我们服务专员将在30分钟内给您回复