UPDATE user SET user_password = md5(CONCAT('1-',md5('newpassword'))) where user_id=1;
where 1 is the userid. It appears twice in the command.
Note the user table might have a prefix.
source
