Basically you need to enter:

 mysql> SET PASSWORD FOR
     -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');