- Stop the mysqld daemon process.
- Start the mysqld daemon process with the –skip-grant-tables option.
- Start the mysql client with the -u root option.
- Execute the UPDATE mysql.user SET Password=PASSWORD(‘password’) WHERE User=’root’;
- Execute the FLUSH PRIVILEGES; command.
If the user knows his/her existing MySQL root password, steps 1-3 are not necessary.
*** Hope this helps!!! Guide was taken from www.tech-faq.com