ERROR 1045 (28000): Access denied for user root@localhost (using password:yes) workaround

1045 This problem can be resolved by changing the password, the following is unable to log in the case of the change password:

Enter the MySQL bin directory under DOS, enter mysql-uroot-p and then enter the password or a 1045 error will occur, such as

Workaround:

1, not-p login

2, execute UPDATE statement to change password

UPDATE mysql.user SET password=password (' New password ') where user= ' root ' and host= ' localhost ';

3,mysql> FLUSH privileges;

Mysql> quit
# mysql-uroot-p
Enter Password: < Enter a new password newpassword> login successful

ERROR 1045 (28000): Access denied for user [email protected] (using password:yes) workaround