Mysql

My Sql Error 1396 (Hy000): Operation Create User Failed For 'user'@'localhost'

Posted by Weston Ganger on April 27, 2014

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

Posted in Linux and Tagged with mysql 


Need help on your next project or application?

I specialize in Ruby-on-Rails, AngularJS, Javascript, Bootstrap, and Hybrid Mobile Apps with Cordova & Ionic.

Contact Me

Recommended Posts