MySQL 5.6 bug

Https://dev.mysql.com/doc/refman/5.6/en/account-management-sql.html

Use MySQL;

SELECT Host,user from User;

"BUG"
CREATE USER ' xx ' @ '% ' identified by ' yy '; GRANT all privileges on * * to ' xx ' @ '% ' with GRANT OPTION;
#ERROR 1045 (28000): Access denied for user ' xx ' @ ' localhost ' (using Password:yes)
CREATE USER ' xx ' @ ' localhost ' identified by ' yy '; GRANT all privileges on *. * to ' xx ' @ ' localhost ' with GRANT OPTION;

DROP USER ' xx ' @ '% ';
DROP USER ' ll ' @ '% ';

"5.6 Invalid, without restarting the service; 5.7, reboot"
UPDATE user SET password= ' newyy ' WHERE user= ' xx ';
#ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number
#SET PASSWORD for ' xx ' @ ' localhost ' = ' 123 ';

Effective
SET PASSWORD for ' xx ' @ ' localhost ' = PASSWORD (' 123 ');

Mysql> SELECT host,user from User;
+-------------------+------+
| Host | User |
+-------------------+------+
| % | xx |
| 127.0.0.1 | Root |
| :: 1 | Root |
| bigdata-server-02 | |
| bigdata-server-02 | Root |
| localhost | |
| localhost | Root |
| localhost | xx |
+-------------------+------+
8 rows in Set (0.00 sec)

SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' root123 ');
SET PASSWORD for ' root ' @ ' 127.0.0.1 ' = PASSWORD (' root123 ');
SET PASSWORD for ' root ' @ ' bigdata-server-02 ' = PASSWORD (' root123 ');
SET PASSWORD for ' root ':: 1 ' = PASSWORD (' root123 ');

MySQL 5.6 bug