Access denied for user ' root ' @ ' localhost ' (using password:yes) solution

Want to enter the database, found that no entry, error access denied for user ' root ' @ ' localhost ' (using Password:yes)

Tried a lot of methods can not, and then solved the

Workaround:

1. Stop MySQL First

shell># Service mysqld Stop

2. The meaning of this code is probably the start
MySQL does not start grant-tables, authorization form

shell># mysqld_safe--user=mysql--skip-grant-tables--skip-networking &

3. Go to MySQL

Shell "# mysql-uroot MySQL

4. View the database, whether there is a MySQL database and select MySQL database

Mysql> Show databases

mysql> use MySQL

5. Delete user-empty data

mysql> Delete from user where user= ';

6. Reset Password

mysql> Update user set Password=password (' Password you want to set ') where user= ' root ';

7. Refresh Permissions

mysql> flush Privileges;

8. Exit

Mysql> exit;

9. Restart MySQL

shell># Service mysqld Restart

10. Test, get it done!

Access denied for user ' root ' @ ' localhost ' (using password:yes) solution