彻底mysql出现用户已存在

如果你在使用MySQL的过程中,出现了"ERROR 1396 (HY000): Operation CREATE USER failed for 'username'@'localhost' with password_expired"的错误提示,它意味着你的用户已存在。

mysql>CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; ERROR 1396 (HY000): Operation CREATE USER failed for 'username'@'localhost' with password_expired