MySQL Login error "Access denied for user ' root ' @ ' localhost ' (using Password:yes" processing method)

Recently logged on to a server MySQL total error:

Access[[email protected] ~]# mysql-u root-p

Enter Password:

ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no) denied for user ' root ' @ ' localhost ' (usi ng Password:no)

I wonder if the password is forgotten ... Then prepare to change the password:

#mysqladmin-u root-p password 123456 # # #设置root密码为123456

Enter Password:

Mysqladmin:connect to server at ' localhost ' failed

Error: ' Access denied for user ' root ' @ ' localhost ' (using Password:yes) '

Still reported this error ... The egg hurts, Baidu a bit, finally found the method as follows:

Method One:

#/etc/init.d/mysqld Stop

# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &

# mysql-u Root MySQL

mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';

mysql> FLUSH privileges;

Mysql> quit

#/etc/init.d/mysqld Restart

# mysql-uroot-p

Enter Password: < Enter the newly set password newpassword>

Mysql>

Method Two:

Use the user name and password provided directly in the [client] section of the/etc/mysql/debian.cnf file:

# mysql-udebian-sys-maint-p

Enter Password: < Enter the password for the [client] section >

mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';

mysql> FLUSH privileges;

Mysql> quit

# mysql-uroot-p

Enter Password: < Enter the newly set password newpassword>

Mysql>

Method Three:

This method I have not been tested, because my root user default password has been modified by me, the person has time to test, the results told me, thank you!

# mysql-uroot-p

Enter Password: < Enter the password provided in the [Client] section of the/etc/mysql/debian.cnf file >

At this point, the problem solved a long puzzle!

MySQL Login error "Access denied for user ' root ' @ ' localhost ' (using Password:yes" processing method)