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;

Read More:

• MySQL local connection Error 1130_ The solution of MySQL 1130 error report when remote connection through Navicat for MySQL
• MySQL error — multiple methods of failed to find valid data directory and MySQL setting password appear
• MySQL – ERROR 1146 (42S02): Table ‘mysql.user’ doesn’t exist
• MySQL error set: failed to start mysql.service : Unit mysql.service is masked.
• MySQL: if the remote connection using navicatip fails, prompt “is not allowed to connect to this MySQL server”
• The MySQL service suddenly hangs up with the error message can’t connect to MySQL server on ‘localhost’ (10061)
• Question: cannot create windows service for mysql.error : 0 (install MySQL)
• Mysql Error:The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not exist
• It can’t connect to local MySQL server through socket ‘/ tmp/ mysql.sock ‘(2) “;
• PHP connection to MySQL database error: call to undefined function MySQL_ connect()
• Navicat for MySQL error 1251 failed to connect to MySQL
• After installing MySQL again under Linux, the solution of ‘MySQL module failed to start’ appears
• Error in installing MySQL devel for CentOS MySQL
• Golang MySQL error SQL: unknown driver “MySQL” (Forgotten import?) solution
• [MySQL] error 1396 (HY000): Operation create user failed for ‘MySQL’ @’localhost ‘
• MySQL Workbench: Error Code: 2013. Lost connection to MySQL server during query solution
• (error when importing database): MySQL 2006-mysql server has gone away
• MySQL Workbench Failed to Connect to MySQL at 127.0.0.1:3306 with user root Bad handshake
• MySQL installation failed: dpkg: error processing package MySQL server (- – configure): dependency problem
• django.core.exceptions . improveconfigured: error loading MySQL DB module. Django configuring MySQL database