Reset MySQL Password

Reset your MySQL Password in 5 Steps:

1. Stop the mysqld daemon process.

2. Start the mysqld daemon process with the –skip-grant-tables option.

3. Start the mysql client with the -u root option.

4. Execute the UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’;

5. Execute the FLUSH PRIVILEGES; command.

With these steps you will reset the password for the root account to “password”. Edit the variables in single-quotes in step 4 to change the password for a different account, or to set a another password.

If you know your current MySQL root password, you wont need steps 1-3.