I am currently looking for a software/web development job preferably as a Rails-based developer.
Please email me at firstname.lastname@example.org. Thanks in advance for any leads!
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';