MySQL錯(cuò)誤處理

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

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

mysql> FLUSH PRIVILEGES; 這里執(zhí)行這個(gè)命令并不能解決問題

Query OK, 0 rows affected (0.00 sec )

下面仍然報(bào)錯(cuò)

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

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

使用 drop user 才可以解決這個(gè)問題:

mysql> drop user newUser@localhost;

Query OK, 0 rows affected (0.05 sec)

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