MySQL创建用户报错ERROR 1396 (HY000): Operation CREATE USER failedfor 'bkuser'...

jiawang

报错现象：
mysql> CREATE USER 'bkuser'@'localhost' IDENTIFIED BY 'bkuser';
ERROR 1396 (HY000): Operation CREATE USER failed for 'bkuser'@'localhost'

mysql> drop user 'bkuser'@'localhost';
Query OK, 0 rows affected (0.10 sec)

使用drop user语句删除用户，可能是之前删除用户lwx的时候有问题，例如从user表删除就会出现这样的问题


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

mysql> CREATE USER 'bkuser'@'localhost' IDENTIFIED BY 'bkuser';
Query OK, 0 rows affected (0.01 sec)