mysql> CREATE USER 'sonar' IDENTIFIED BY 'sonar'; ERROR 1396 (HY000): Operation CREATE USER failed for 'sonar'@'%' code example

Example 1: 1396(hy00) mysql error

drop user someuser;
flush privileges;

grant all privileges on *.* to 'someuser'@'localhost' with grant option;