Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This question already has an answer here:

Is there a mysql command to reset the root password?

I am trying

 mysql -p -u root

but I've forgotten the password.

Is there any way to reset the password?

share|improve this question

migrated from Dec 9 '10 at 1:42

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

marked as duplicate by Chris S Mar 20 '13 at 5:35

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

See – David Kuridža Dec 8 '10 at 11:12
With a name like "All is well" you really shouldn't have these issues. – John Gardeniers Dec 9 '10 at 4:49

Check the doc

Basically this should be

mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
    ->                   WHERE User='root';
share|improve this answer
Password is required first to run this query – All is well Dec 8 '10 at 11:42
You need to run it as start-up SQL for the database daemon - read the link. – Rup Dec 8 '10 at 11:44

You can start the mysql-daemon with the argument --skip-grant-tables, then you can login without prompt and alter passwords.

share|improve this answer

If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To setup root password for first time, use mysqladmin command at shell prompt as follows:

$ mysqladmin -u root password NEWPASSWORD

However, if you want to change (or update) a root password, then you need to use following command

For example, If old password is abc, and set new password to 123456, enter:

$ mysqladmin -u root -p'abc' password '123456'


share|improve this answer
Password is required first to run this query – All is well Dec 8 '10 at 11:42