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

   sudo /etc/init.d/mysql stop

2. Start MySQL with the following command

   sudo mysqld --skip-grant-tables &

3. Login to MySQL as root with out a password

   mysql -u root mysql

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

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