Resetting MySQL root password from the CLI

Seems like I always end up searching for this so I thought I would add it to my site for easy reference.

1. Stop MySQL
   
   PHP

   sudo /etc/init.d/mysql stop

   1	sudo /etc/init.d/mysql stop

2. Start MySQL with the following command
   
   PHP

   sudo mysqld --skip-grant-tables &

   1	sudo mysqld --skip-grant-tables &

3. Login to MySQL as root with out a password
   
   PHP

   mysql -u root mysql

   1	mysql -u root mysql

4. Replace PASSWORD with the new password of your choice.
   
   PHP

   UPDATE user SET Password=PASSWORD('PASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;

   1	UPDATE user SET Password=PASSWORD('PASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;