I installed MySQL on a Mac OSX Snow Leopard and got the mysql service started but I couldn't login as root to reset the password.

  1. Couldn't login as root either.

    $ ./mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

  2. Neither did mysqladmin work

    ./mysqladmin -u root password "password" ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)'

How do set/reset my MySQL password ?

link|improve this question
Try a blank password like - mysql -u root -p mysql password option – arunkumar Oct 15 '11 at 12:51
Tried that - doesnt log in. – anjanesh Oct 15 '11 at 13:01
feedback

migrated from stackoverflow.com Oct 15 '11 at 19:07

This question came from our site for professional and enthusiast programmers.

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.