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語(yǔ)句刪除用戶，可能是之前刪除用戶lwx的時(shí)候有問(wèn)題，例如從user表刪除就會(huì)出現(xiàn)這樣的問(wèn)題 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)

總結(jié)

以上是生活随笔為你收集整理的MySQL创建用户报错 -- ERROR 1396 (HY000): Operation CREATE USER failed for ‘user_name‘@‘localhost‘的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。