Cause:
First delete the user, then create the user, execute the SQL:

 create user yong@localhost identified by '111111'

Exception:

ERROR 1396 (HY000): Operation CREATE USER failed for 'yong'@'localhost'

Solution:

flush privileges;
drop user yong@localhost;
flush privileges;