How to solve the problem of forgetting mysql database administrator password

We will use the MySQL database when programming under the Windows operating system. But sometimes, we forget the database login password? What should we do when we forget our login password and cannot enter mysql? Here we provide the modification of mysql login secret.

1. Enter the command mysqld --skip-grant-tables (prerequisite is to close the mysql.exe process net stop mysql)

2. Enter the command mysql

Complete database entry without password~

3. Change username and password

mysql -uroot -p1234

Red For places that can be changed, username and password

##Related recommendations:

Jenkins Changing Administrator Password Instance Tutorial

Recovering the MySQL administrator password under Linux、

Remedies for forgetting the administrator password

The above is the detailed content of How to solve the problem of forgetting mysql database administrator password. For more information, please follow other related articles on the PHP Chinese website!