Mysql8.0 The above method of resetting when forgetting the initial password

• Abstract
• • First step ： close Mysql service
  • The second step ： skip Mysql Password authentication
  • The third step ： Enter without password Mysql
  • Step four ： Set the login password to blank
  • Step five ： Change your login password
• The last step ： Verify that the password was modified successfully

Abstract

Most of the methods on the Internet are through My.ini or My_default.ini Add –skip-grant-tables Method to skip Mysql Password to connect to the database , And change the password .
I spent nearly three hours using the online method , Want to skip the database login password through these methods , To change the initial password . It's a complete waste of three hours of my time .
After a period of groping , I finally found a feasible way .
The following command line code operates in administrator mode
Command line exe File directory ：C:WindowsSystem32cmd.exe -> Right click -> With " Run in administrator mode "

First step ： close Mysql service

First , Make sure you're closed Mysql Service for

cd c:webmysql-8.0.16in( Enter your own here Mysql Installation address )
net stop mysql

The second step ： skip Mysql Password authentication

close Mysql After the service , Continue to C:webMysql-8.0.16in Operating under the directory
Input

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

After entering this line of code , We have successfully skipped Mysql Login with your password

The third step ： Enter without password Mysql

After the above steps , Open another administrator mode cmd.exe
Get into mysql Under the bin After the directory , Direct login mysql
No need to pass net start mysql open mysql service
Enter the following code on the command line

cd c:webmysql-8.0.16in( Enter the installation directory on your computer here )
mysql -u root -p

A message appears asking you to enter your password , Directly enter , You can successfully connect Mysql

Step four ： Set the login password to blank

Enter the code , Set password to empty （ You cannot change the password directly at this time , Must be set to null first , Otherwise, an error will be reported ）
Input

use mysql; ( Use mysql Data sheet )
update user set authentication_string='' where user='root';（ Leave the password blank ）
quit; ( And then quit Mysql)

Step five ： Change your login password

There are two parts here

1. Close the first cmd window ( Be sure to close ！)

2. Enter the code in the second window

net stop mysql( close mysql service , Although it will show that the service is not enabled , But just in case ) net start mysql( And on again mysql service ) ( Don't bother here , If the last one mysql The service is not closed , We still log in without password ) cd C:webmysql-8.0.16in mysql -u root -p ( Enter password... Will be displayed here , Just go straight back , Step 4 we have left him empty ) ALTER USER 'root'@'localhost' IDENTIFIED BY ' New password ';（ Change password ）

The last step ： Verify that the password was modified successfully

quit（ sign out mysql）
mysql -u root -p 
( Enter the new password , Log in again )
 success ~~~