Solution to forgetting mysql database password

# 1. First shut down the current MySQL server. # Start by command (let MySQL skip the username and password verification function)
# mysqld --skip-grant-tables
# Start on the server and open cmd as an administrator 

# 2. Connect directly without a password # mysql -uroot -p and press Enter 

# 3. Modify the password of the current user. # The user information is stored in user.frm in the mysql folder. # update mysql.user set password=password(new password) where user='root' and host='localhost';
'''
The field that actually stores the password of the user table must be stored in ciphertext. Only the user himself knows what the plaintext is, and no one else knows it. This is more secure. Password comparison can only compare ciphertext. MySQL calls the password() method to encrypt the password.''' 

# 4. Immediately flush the modified data to the hard disk # flush privilege; 

# 5. Close the current server and then start it in the normal way of verifying the authorization table