Change MySQL user password

To change the password for a MySQL user, run

mysqladmin -u user_name_here -p password new_password_here

Or via SQL

UPDATE mysql.user SET Password=PASSWORD('NEW_PASSWORD_HERE') WHERE User='USER_NAME_HERE';
FLUSH PRIVILEGES;