《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)
维易PHP培训学院每天发布《MySQL错误处理》等实战技能,PHP、MYSQL、LINUX、APP、JS,CSS全面培养人才。
转载请注明本页网址:
http://www.vephp.com/jiaocheng/7664.html