My Sql Error 1396 (Hy000): Operation Create User Failed For 'user'@'localhost'
Posted by Weston Ganger
Just installed MySQL trying to create my first user
Anyways to fix the issue I ran these 3 commands within the mysql prompt:
DROP USER user@localhost; FLUSH PRIVILEGES; CREATE USER user@localhost IDENTIFIED BY 'password';