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)