Seems like I always end up searching for this so I thought I would add it to my site for easy reference.
- Stop MySQL
PHP1sudo /etc/init.d/mysql stop
- Start MySQL with the following command
PHP1sudo mysqld --skip-grant-tables &
- Login to MySQL as root with out a password
PHP1mysql -u root mysql
- Replace PASSWORD with the new password of your choice.
PHP1UPDATE user SET Password=PASSWORD('PASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;