Must SET PASSWORD before executing this statement resolve

Reference to the previous use of Safe mode login, and then modify the password, is equal to the MySQL set the password. After logging in, you want to create a database test. The results are indeed:

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

Very strange ah, clearly with the password login, how also prompted the need for a password.
Refer to one of the official documents, see http://dev.mysql.com/doc/refman/5.6/en/alter-user.html. OK after the following operation:

mysql> CREATE DATABASE Yan1;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
mysql> SET PASSWORD = PASSWORD (' 123456 ');
Query OK, 0 rows affected (0.03 sec)

mysql> CREATE DATABASE Yan1;
Query OK, 1 row Affected (0.00 sec)

That is, use the mysql> set PASSWORD = PASSWORD (' 123456 ') to reset the password once. Big uncle's, really laborious ah.
The man also encountered the same problem.