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

There was no problem connecting to the database yesterday, but today this error was reported when connecting to the database. I searched a lot of methods on the Internet and found one method that solved my problem. My environment is Linux

Steps: First, you need to skip password authentication. Find the /etc/my.cnf file in the Linux environment, find mysqld in the file, and add the skip-grant-tables statement under mysqld to avoid password verification. Then restart mysql, /etc/init.d/mysqld restart, and change the password.

as follows,

mysql> use mysql;
mysql> update user set password=password("your new password") where user="root";
mysql> flush privileges;
mysql> quit

Then restart MySQL, use the same statement as above, the problem is solved. If you want to modify the username at the same time, you can use the following statement:

mysql> use mysql;
mysql> update user set password=password("your new password"), user="(user name to be modified)" where user="root";
mysql> flush privileges;
mysql> quit

Summarize

The above is all the content of this article about MySQL error solutions. I hope it will be helpful to everyone. Interested friends can continue to refer to this site: Brief analysis of the MySQL character set causing database recovery errors, analysis of MySQL table sorting rules different error problems, etc. If you have any questions, you can leave a message at any time, and the editor will reply to you in time.