《MySQL錯(cuò)誤處理》要點(diǎn)：
本文介紹了MySQL錯(cuò)誤處理，希望對(duì)您有用。如果有疑問(wèn)，可以聯(lián)系我們。
mysql> CREATE USER 'newUser'@'localhost' IDENTIFIED BY 'gitlab!@#';
ERROR 1396 (HY000): Operation CREATE USER failed for 'gitlab'@'localhost'
mysql> FLUSH PRIVILEGES; 這里執(zhí)行這個(gè)命令并不能解決問(wèn)題
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è)問(wèn)題:
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)
維易PHP培訓(xùn)學(xué)院每天發(fā)布《MySQL錯(cuò)誤處理》等實(shí)戰(zhàn)技能，PHP、MYSQL、LINUX、APP、JS,CSS全面培養(yǎng)人才。
轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/7664.html
