Change password for particular user

Needed in case a old password needs to be set or if the password is working anymore after a change to a higher PHP Verion. (Changes in the hashing as of PHP 5.4)

UPDATE USER SET Password = PASSWORD('FILL-PASSWORD') WHERE USER = 'webXYZ';
FLUSH PRIVILEGES;