MySQL forgot database password

1. Stop the MySQL service

2. Open the command line as an administrator, enter the MySQL folder, mysqld--skip-grant-tables

3. Alternatively, open a command line as an administrator and enter MySQL directly to access the database.

4. Enter show databases; You can see all the database instructions successfully logged in.

5. Change the password

Use MySQL;

Update user set Password=password (' 123456 ') where user= ' root ' and host= ' localhost ';

Select User,host,password from user;

FLUSH privileges;

6. Restart the service

MySQL forgot database password