How does mysql forget the root password?

Mysql forgot the root password solution 1. Stop mysql Service 2. Enter mysqld -- skip-grant-tables in the command line (skip permission check to start mysql Service) 3. Enter updateMySQL in the command line. usersetpasswordPASSWORD (new password) whereUserroot; flushprivileges; quit4 restart mysql Service

Mysql forgot the root password solution 1. Stop mysql Service 2. Enter mysqld -- skip-grant-tables in the command line (skip permission check to start mysql Service) 3. Enter update MySQL in the command line. user set password = PASSWORD ('new password') where User = 'root'; flush privileges; quit 4. Restart the mysql Service

How to solve the problem of forgetting the root password of mysql
1. Stop the mysql Service
2. command line Input

Mysqld -- skip-grant-tables (skip permission check to start mysql Service)

3. command line Input

Update MySQL. user set password = PASSWORD ('new password') where User = 'root'; flush privileges; quit

4. Restart the mysql service.