MySQL:ERROR 1396 (HY000): Operation CREATE USER failed for 'gituser'@'localhost'
例如:用户gituser
密码git12345678
创建一个已经存在过的用户,即使已经执行过 delete from mysql.user where User='gituser'
再重新创建用户也会报错,如下(gituser账号已经存在过的,并且delete删除过):
mysql> CREATE USER gituser@localhost IDENTIFIED BY 'git12345678'; ERROR 1396 (HY000): Operation CREATE USER failed for 'gituser'@'localhost'
解决方法:(执行完后重新创建用户)
drop user "gituser"@"localhost";
本文作者为SKY RING,转载请注明。