MySQL password reset in Windows

Posted by Unknown at 01:27
1. Stop the MySQL service

2. Go to the MySQL installation folder

3. Find the file my.ini

4. Add the line “skip-grant-tables = 1? in my.ini

5. Start MySQL service

6. Now, in command prompt, go to the MySQL bin folder, type ‘mysql’

7. Execute the following command

UPDATE user SET Password=PASSWORD(’YOUR_PASSWORD’) WHERE Host=’localhost’ AND User=’root’;

8. Remove the line “skip-grant-tables = 1? from my.ini

9. Restart MySQL service
Labels: ,

3 comments:

  • Robert Christopherso
    30 November 2010 at 18:15

    You made some fine points there. I did a search on the topic and found nearly all persons will agree with your blog.

  • Smoking Side Effects
    29 January 2011 at 21:30

    How did you create such a great site? It must have took alot of efforts lol

  • 2011 Honda Civic
    23 February 2011 at 12:01

    I found your site being bookmarked in one of the social sites. Im glad I visited it. Interesting articles you have here.

    • Post a Comment

    Subscribe to: Post Comments (Atom)