MySQL创建用户报错 -- ERROR 1396 (HY000): Operation CREATE USER failed for ‘user_name‘@‘localhost‘

mysql> CREATE USER 'lwx'@'localhost' IDENTIFIED BY '123456';
ERROR 1396 (HY000): Operation CREATE USER failed for 'lwx'@'localhost'

mysql> drop user 'lwx'@'localhost'; # 使用drop user语句删除用户，可能是之前删除用户lwx的时候有问题，例如从user表删除就会出现这样的问题
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> CREATE USER 'lwx'@'localhost' IDENTIFIED BY '123456';
Query OK, 0 rows affected (0.00 sec)