MySQL Flash-back issues under Windows

Early to start MySQL found the input password on the flash back, tried several times, and finally to the Internet to find a solution.

The procedure for MySQL password loss is basically the same as the Linux system.

Start the MySQL service by skipping the password first.

The start service must use the full path, while Windows is prone to error, where we choose to set environment variables.

Advanced system settings-environment variables-Add the bin path under the MySQL installation directory.

On the Windows command line input: Mysqld-nt--skip-grant-tables (do not exit first)

In the MySQL command line directly without password login, change password, command as follows:

>use MySQL;

>update User Set password = ' xxx ' where user = ' root ';

This will restart the service.

MySQL Flash-back issues under Windows