Kill lui lei dog---linux no:35 linux under the MySQL password forget solution

If the password is forgotten, we will kill the process directly.

This is a typical error with a bad password.

Then we use Pkill directly to kill his progress.

Then check for checks:

It's been successfully killed. Then start MySQL:

. / -- skip-grant-table

The carriage return looks like this:

Don't ctrl + C Oh, or he'll be turned off. Open multiple Windows directly from the new one as follows:

Start MySQL directly without the password will come in ...

Use MySQL database, modify the Users table, authencation_string field.

and find the user table inside.

Then find authentication_string:

and check him out.

Select Host,userfromuser;

Modify the root password directly in this area:

Because MySQL has his own encryption method, so use the built-in cryptographic function password, so that encryption succeeds.

The next step is to kill mysqld, as shown below:

After killing, reboot again as follows:

. / -- User=mysql &

Then PS look down up the wood there:

The discovery has been up ...

And then even:

See password errors This error, it is much simpler, the connection method is as follows:

OK, perfect solution.

Kill lui lei dog---linux no:35 linux under the MySQL password forget solution