The sql syntax is as follows and you must login as root (mysql server administrator) user account:
SET PASSWORD FOR 'user'@'host' = PASSWORD('password');
UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='user' AND Host='host';
You must flush the privileges
FLUSH PRIVILEGES;Read answer to: "MySQL Change a User Password"