Windows next MySQL password forgot to change

1. To the scene MySQL introduction My.ini
2. Added to the following [Mysqld] Skip-grant-tables
3. Win+r hotkey into cmd and then enter the command net stop MySQL last point, make folders MySQL folder under folder of Bin
4. Input command mysqld-nt--skip-grant-tables (local test hint a waring does not seem to affect)
5. Win+r the shortcut key again enter CMD and enter the command mysql-u root return, this time should enter MySQL
6. Select Database user mysql;
7. Change Password:update user Set Password=password ("New password") where user= ' root '; Note The uppercase password is encrypted with the new password three characters replaced with their own password
8. Kill the MYSQLD-NT process in Task Manager
9. Delete the content added in the second entry
10. Restart MySQL
11. Enter a new password test.

    Watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqvc2x5aml0/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70 /gravity/southeast ">

Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.

Windows next MySQL password forgot to change