Windows forgot the Mysql root password change method _mysql

MySQL database forgot the root password is a very painful thing, this article describes how to resolve the Windows environment MySQL server forget root password solution.

1. Turn off MySQL service

Window+r run input net stop MySQL

2. Open the command line in the MySQL bin directory

shift+ the right mouse button----> find here to open a command window

3. Input Mysqld-nt--skip-grant-tables

The message ends with "set to OFF", indicating success

4. Same location open another command line, enter MySQL, carriage return

5. Input use MySQL;

6.update user Set Password = password ("New password") where user= "root";

7.flush privileges;

8.quit;

9. Start MySQL Service

Run net stop MySQL

10. Enter the cmd test,

Mysql-uroot-p

The above is a small set of Windows to introduce you to forget the MySQL root password change method, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!