Solution to MySQL root password error number 1045

Stop MySQL Service

Windows can right-click My Computer--Manage--Services and Applications--Services--find the corresponding service and stop it

Password-free login

Switch to the MySQL installation path: D:\mysql-5.7.24-winx64\bin; if the environment variable has been configured, you do not need to install the directory again

Open a CMD command window and enter the following command in the command line: mysqld -nt --skip-grant-table

For databases older than 8.0, run the following command: mysqld --console --skip-grant-tables --shared-memory

Enter the database

Restart a cmd command window as an administrator, enter: mysql -uroot -p, Enter to enter the database

If you don't want to change the password, but just want to see the original password, you can execute this statement in the command line

select host,user,password from mysql.user; //You can view the user and password

Note: There is no password field in MySQL 5.7 and above. It is encrypted and changed to authentication_string

Change Password

Execute the following statements in the command line

use mysql
update user set password=password("new_password") where user="root"; // Change 'new_password' here to the password you want to set flush privileges;
quit

Note: In MySQL 5.7 and above, replace the statement with

update mysql.user set authentication_string=password('new_password') where user='root'; // Change 'new_password' to the password you want to set

MySQL 5.7 version password setting rules:
It must contain at least one uppercase letter, one lowercase letter, one special symbol, and one number. The password must be at least 8 characters long.

Restart MySQL

Restart MYSQL and enter your password to log in!

mysql -u root -p Enter the password and log in successfully

Summarize

This is the end of this article about how to solve MySQL root password error number 1045. For more information about MySQL root password forgetting, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!