Access denied for user & #39; root & #39; @ & #39; localhost & #39; (using password: YES) Error solution for mysql connection in Linux, mysqldenied

Access denied for user 'root' @ 'localhost' (using password: YES) Error solution for mysql connection in Linux, mysqldenied
Connect to mysql in linux/Usr/local/mysql/bin/mysql-uroot-pWhen you enter the password, the following error occurs: Access denied for user 'root' @ 'localhost' (using password: YES.

Solution:

1. Stop the mysql service first

Service mysqld stop

2. Go to the mysql installation directory bin/use safe mode and restart:

./Mysqld_safe -- skip-grant-tables

3. Use the root account and log on without a password. Change the root user password.

Mysql-u root use mysqlupdate user set password = PASSWORD ("your password") where User = 'root ';

4. Restart mysql and log on normally

Service mysqld restart

/Usr/local/mysql/bin/mysql-uroot-p and enter the Reset Password.

Finished. Connection successful!