Change/update MySQL password

To change the MySQL password for a particular user first login to MySQL:

mysql -u root -p

Next update the appropriate user's password with the following command:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('NEW_PASSWORD');