How to solve the error when connecting to MySQL in Linux: Access denied for user 'root'@'localhost'(using password: YES)

Preface

Recently connected to mysql /usr/local/mysql/bin/mysql -uroot -p

When I enter the password, an error message appears: Access denied for user 'root'@'localhost'(using password: YES) . Let’s take a look at the detailed solution.

Solution:

1. Stop the mysql service first

service mysqld stop 

2. Enter the MySQL installation directory bin/ and use safe mode to restart:

./mysqld_safe --skip-grant-tables 

3. Use the root account, log in without a password, and change the root user password

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

4. Restart mysql and log in normally

service mysqld restart 

/usr/local/mysql/bin/mysql -uroot -p and then enter the password you just reset

Done, connection successful!

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support for 123WORDPRESS.COM.