Exploring Flex

Reset password in WAMP server

Posted by hneelu on February 18, 2009

Go to Command Prompt
C:\wamp\bin\mysql\mysql5.0.51b\bin

[To find the proper folder, go into your wamp folder using Windows Explorer, click “bin”, “mysql”, then find where the other “bin” folder is under that.]

In the command promt type :
mysqladmin -u root password NEWPASSWORD
where NEWPASSWORD is the new password.

8 Responses to “Reset password in WAMP server”

  1. elvin said

    you are a genious. an error occurred with my Mysql while changing the root password and i could not log in. i googled for half an hour and found nothing helpful to change my password. this worked. good job!!!!!!
    elvin xhimitiku

  2. Awesome tip, thank you! This, I am sure will come in handy when I accidentally lock myself out. Here is a great and simple tutorial on how to change the root user’s password in Wamp on Windows based machines if anyone is interested: http://www.itutorblog.com/2011/06/how-to-change-root-password-on-wamp/

  3. Mike Heath said

    I’ve gone through this process but the cmd message is ‘…failed error: ‘Access denied for user ‘root’@’localhost’ (using password: NO)’

    What now?

    • b74ck4ng37 said

      Check the status of your mysql service (or wampmysqld service if your running wamp)
      Make sure you have an admin cmd line.
      reboot and try again?

      Hope it helps.
      Greetings.

  4. blu ray 3d player reviews…

    […]Reset password in WAMP server « Exploring Flex[…]…

  5. kristobaldude said

    Nice post. I was never able to get this method to work for resetting WAMP password, but I’ve seen in other forums it has worked for lots of people.

    Feel free to check out my blog when you get a chance. I’ve only just starting writing posts, but I’ve got a lot of ideas now being a web developer in the daytime :0)

    Regards,
    -CodeSlayer2010

  6. kristobaldude said

    Oops… here’s my programming blog:
    http://codeslayer2010.wordpress.com/

  7. domains said

    Hello, for all time i used to check web site posts here in the early hours in the daylight, since i
    love to gain knowledge of more and more.

Leave a reply to Mike Heath Cancel reply