How to reset the root user password of the mysql database

If you forget how to reset the password of the root user in the mysql database, refer.

If you forget how to reset the password of the root user in the mysql database, refer.

I first introduce the environment I use:

1. windows;

2. php Service Manager wamp5;

Let's talk about the following:

1. Open the task manager and end the process mysqld-nt.exe

2. Run Command window

1). Run the "bin" directory in the php Service Manager installation directory (my directory is "D: \ wamp \ mysql \ bin ),

Operation:

For example, mysqld-nt -- skip-grant-tables; press ENTER

(4) At this time, the cursor can only Flash and cannot be operated, that is, it is a huge step of success;

For example:

2) open another command window:

Operation:

(1) run the following command in the bin directory of the php Service Manager installation directory:

For example: