About MySQL Login exception handling methods-MySQL ERROR 1045 (28000)

Today, in the development process encountered a very troublesome problem??

Use Baidu Experience steps "http://jingyan.baidu.com/article/495ba841ef412d38b30edeb2.html" to modify the root password, resulting in a variety of errors can not be logged, such as:

MySQL ERROR 1045 (28000).

Find a lot of methods, the most typical is Skip-grant-tables method, but, I can not try.

Very disdain, and suddenly came to the inspiration. Ha ha

Here is my personal solution to "MySQL forgot password steps".

　　Description: This method may only apply to MySQL decompression version, if as learning, please try, if the enterprise production, please carefully consider!

1. Stop MySQL service + Delete Service

2. Locate the "MySQL" folder in the database

3. Delete to Recycle Bin "have regret medicine to eat"-and copy a new initialized MySQL database folder

Haha, see here, should know what I want to do

4. Open a new CMD command window

5. Modify the root password using the correct password change command

6. This is done, take a breath. Ha ha

Experience: The development process of accumulating experiences, the brain will become more and more light, the way will be more and more.

So, I can use a lot of methods to deal with a problem, this is experience!!!

About MySQL Login exception handling methods-MySQL ERROR 1045 (28000)