MySQL错误处理（mysql 错误）

mysql> CREATE USER 'newUser'@'localhost' IDENTIFIED BY 'gitlab!@#';

ERROR 1396 (HY000): Operation CREATE USER failed for 'gitlab'@'localhost'

mysql> FLUSH PRIVILEGES; 这里执行这个命令并不能解决问题

Query OK, 0 rows affected (0.00 sec )

下面仍然报错

mysql> CREATE USER 'newUser'@'localhost' IDENTIFIED BY 'gitlab!@#';

ERROR 1396 (HY000): Operation CREATE USER failed for 'gitlab'@'localhost'

使用 drop user 才可以解决这个问题:

mysql> drop user newUser@localhost;

Query OK, 0 rows affected (0.05 sec)

mysql> CREATE USER 'newUser'@'localhost' IDENTIFIED BY 'gitlab!@#';

Query OK, 0 rows affected (0.00 sec)