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';

Article Topic:Software Development - Linux

Date:April 26, 2014

Recommended Posts

Contact

604-309-8713
info@solidfoundationwebdev.com

Send Me A Message

I would love to get in touch and talk about your next project. Feel free to send a message and I will get back to you shortly.

Get Connected