Resetting a mysql root password

*sigh* again!

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.

From: http://www.tech-faq.com/reset-mysql-password.shtml