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, configure MySQL to 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
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("新密码") 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 ~\(≧▽≦)/~
The above is the detailed content of MySQL login error message ERROR 1045 (28000) error solution (picture and text). For more information, please follow other related articles on the PHP Chinese website!