UPDATE `user` SET user_password = CONCAT(‘:A:’, MD5(‘somepass’)) WHERE user_name = ‘someuser’;

http://www.mediawiki.org/wiki/Manual:Resetting_passwords