ERROR 1396 (HY000): Operation CREATE USER failed for 'sonar'@'%'

出现ERROR 1396 (HY000): Operation CREATE USER failed for 'sonar'@'%'，说明sonar用户已经在mysql.user表中建立，若建立该用户，需先删除该用户，步骤如下：

1. delete from mysql.user where user='sonar'; 删除用户

2.CREATE USER 'sonar'@'%'IDENTIFIED BY 'sonar';天假用户

3. flush privileges; 清理缓存

4. select * from mysql.user where user='sonar';查看该用户是否存在 ，结果是null

5.  flush privileges;清理缓存

6. GRANT ALL ON sonar.* TO 'sonar'@'%' IDENTIFIED BY 'sonar';用户操作授权