How to solve the MySQ login prompt ERROR 1045 (28000) error

When we log in to mysql, errors often occur. This article mainly introduces in detail the solution to the MySQ login prompt ERROR 1045 (28000) error. It has certain reference value. Interested friends can refer to it. , hope it can help everyone.

Today, log in to the server and prepare to modify some things in the database. But after entering the password, I cannot enter the database and prompt an error, as shown below

After confirming that the password is correct, I still cannot enter the database. I found the solution online and recorded it for reference and study.

Solution:

General idea: (under Linux system) Close the MySQL service and configure MySQL so that Log in without a password, then reset the password, refresh the database, remove the previous configuration, and restart MySQL.

1. Close the MySQL service, command: service mysqld stop. Find your MySQL configuration file. The location may be different for everyone. For example, my configuration file is as shown below

2. In the directory where the configuration file is located, use vim Command to edit it, command: vim my.cnf

and then enter vim editing mode, that is, press insert, add skip_grant_tables at the specified position in the figure below, as shown in the figure below

3. Save and exit the configuration file, command: ① shift + semicolon ② Enter wq ③ Press the Enter key. This will configure passwordless login. Start the database, command: service mysqld start. Enter the database, type: mysql -u root -p on the command line, and then press Enter to enter the database. O(∩_∩)O

4. After entering the database, set a new password for the database. If you still want to use the previous password, just set it to the previous password. This is also possible.

Command (press Enter after a command):

① use mysql;

② update user set password=password("new password") where user=" root"

③flush privileges;

④ quit;

Note: The second command is suitable for MySQL5.6 and earlier versions. There is no password field after MySql5.7. You should execute update user set authentication_string =password('newpassword') where user='root'; to change the password.

5. After changing the database password, comment out the modified part of the original database configuration file and add a # sign before the statement.

6. Restart the database service, command: service mysqld restart. At this time, you can log in to the database with the password you just set~\(≧▽≦)/~

Related recommendations:

A system error occurred in the green version of Mysql database What to do with 1067?

Detailed explanation of how to solve the problem of MySql inserting data successfully but reporting [Err] 1055 error

Solution to the error 10061 in mysql

The above is the detailed content of How to solve the MySQ login prompt ERROR 1045 (28000) error. For more information, please follow other related articles on the PHP Chinese website!