Using MySQL-Front 2.5 with newer MySQL versions
14 August, 2005 - 23 words
Just for my own reference, because I keep forgetting the syntax and having to Google it:
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');