Tuesday, August 20, 2013

Solving mySql exception: ERROR 1396 (HY000): Operation CREATE USER failed for 'somebody'@'%'

To solve the problem of creating using which raises an error "ERROR 1396 (HY000): Operation CREATE USER failed for 'somebody'@'%'", run the following script with the proper changes(user name and password).


grant all privileges on *.* to somebody@localhost identified by 'password' with grant option;