The perfect solution for forgetting the password in mysql8.0.19

Recommended reading: MySQL 8.0.19 supports account lock function after entering incorrect password three times (example)

1. Open a cmd window (preferably as an administrator), and run net stop mysql to stop the MySQL service.

2. Enable MySQL service that skips password verification

mysqld --console --skip-grant-tables --shared-memory

3. Open a new cmd window and start the mysql service

mysql -u root -p

4. Enter the password and press the space key to skip

5. Leave the password blank

use mysql
update user set authentication_string='' where user='root';
exit

6. Close the MySQL service opened in step 2 (just close the window)

7. Restart the MySQL service and log in without a password

8. Change password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '111111';
flush privileges

Adding WITH mysql_native_password can ensure that navicat connection will not have any problems

Summarize

The above is the perfect solution to the problem of forgetting the password of MySQL 8.0.19 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!