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

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

File contents:

[Client]
host = localhost
user = Debian-sys-maint//username
Password = xgsuj2n8rlvw7juo//password
Socket =/var/run/mysqld/mysqld.sock
[Mysql_upgrade]
host = localhost
user = Debian-sys-maint
Password = Xgsuj2n8rlvw7juo
Socket =/var/run/mysqld/mysqld.sock
Basedir =/usr

At the command line, enter:

# mysql-udebian-sys-maint-p

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

#use MySQL

Mysql>update User Set Password=password ("123456") where user= "root";

Mysql>flush privileges;

Mysql> quit

# mysql-uroot-p

Enter Password: < Enter the newly set password newpassword>

Mysql>

To this success

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