For your must SET PASSWORD before executing this statement workaround _mysql

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 again! Big uncle's, really laborious ah.
The man also encountered the same problem.


Recently new good MySQL in the MySQL tool to enter, there are always error prompts:

# mysql-u Root-p
Enter Password:
ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)
Or
# mysql-u root-p password ' newpassword '
Enter Password:
Mysqladmin:connect to server at ' localhost ' failed
Error: ' Access denied for user ' root ' localhost ' (using Password:yes) '

Now we've finally found a way out. I was going to reload it now.
The method operation is simple, as follows:
#/etc/init.d/mysql Stop
# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &
# mysql-u Root MySQL
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ' and host= ' root ' or host= ' localhost '; It's OK to change the blank user password to a non-empty password.
mysql> FLUSH privileges;
Mysql> Quit #/etc/init.d/mysqld restart
# mysql-uroot-p
Enter Password: < Enter the new password newpassword>

MySql5.6 operation times Wrong: You must SET PASSWORD before executing this statement solve
mysql> SET PASSWORD = PASSWORD (' 123456 ');
Query OK, 0 rows affected (0.03 sec)
mysql> CREATE DATABASE Roger;
Query OK, 1 row Affected (0.00 sec)
That is, use the mysql> set PASSWORD = PASSWORD (' 123456 ') to reset the password again!