Mysql:error: ' Access denied for user ' root ' @ ' localhost '

# mysqladmin-uroot-p password ' newpassword '

Enter Password:

Mysqladmin:connect to server at ' localhost ' failed

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

Now finally I found the solution, as follows (please test method three, thank you!) ）：

Method One:

#/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 ';

mysql> FLUSH privileges;

Mysql> quit

#/etc/init.d/mysql Restart

# mysql-uroot-p

Enter Password: < Enter the new password newpassword>

Mysql>

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/MySQL/

Method Two:

Use the username 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 [client] section >

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

mysql> FLUSH privileges;

Mysql> quit

# mysql-uroot-p

Enter Password: < Enter the new password newpassword>

Mysql>

Method Three:

This method I did not have to test, because my root user default password has been modified by me, that a free test, tell me the results, thank you!

# mysql-uroot-p

Enter Password: < Enter the password provided in the [Client] section of/ETC/MYSQL/DEBIAN.CNF file >

At this point, puzzled over the problem solved!

This article from the "Live Well" blog, please be sure to keep this source http://wolfword.blog.51cto.com/4892126/1219807