Solve mysql: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO/YES)

1. Problem

Sometimes when we log in to Mysql and enter the password, this situation occurs

mysql -u root -p

Enter Password > 'Password'

Error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Or: Error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

2. Solution

Modify the my.in/my.cnf configuration file

Enter the mysql installation directory

Edit my.ini

Add skip-grant-tables under [mysqld] and save the file.

Open a command line as an administrator

①Restart mysql:

1. net stop mysql 2. net start mysql

②Enter mysql, log in mysql -u root -p
No need to enter a password, just press Enter (if Enter Password appears, just press Enter to log in successfully)

③Enter use mysql to change the root password:
update user set authentication_string=password('new password') where user='root';
flush privileges;

④Exit:

quit;

⑤Restart mysql again:

1. net stop mysql 2. net start mysql

⑥Whether the test is successful means whether the login is successful.
mysql -u root -p

Enter Password>'New Password'

There will be no mistakes, you can log in! ! !

(Another situation is that you entered the wrong password. If this is the first time you log in after initialization, it is very likely that the password is wrong. You should carefully check the password after initialization. It may be due to spaces, decimal points and other symbols.)

The above is the detailed content of solving mysql: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO/YES). For more information about ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO/YES), please pay attention to other related articles on 123WORDPRESS.COM!