Reset MySQL Password on Ubuntu

gistfile1.tcsh

# Stop MySQL

sudo /etc/init.d/mysql stop

# Start MySQL skipping checks

sudo mysqld --skip-grant-tables &

# Log in as root

mysql -u root mysql

# Reset password

UPDATE user SET password=PASSWORD('NEWPASSWORD') WHERE user='root';
FLUSH PRIVILEGES;
exit;