适用范围

本文档适用于 MySQL 迁移用户及权限的通用做法。

问题概述

在 mysql 迁移过程中，手动创建用户报：ERROR 1827 (HY000): The password hash doesn't have the expected format. 具体如下

create user test1@'localhost' IDENTIFIED WITH mysql_native_password AS '6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK;          
ERROR 1827 (HY000): The password hash doesn't have the expected format.

问题原因