Magento Articles and Tips for Developers

UPDATE customer_entity_varchar SET VALUE = md5('new_password') 
WHERE entity_id=(SELECT entity_id FROM customer_entity WHERE email='email@hostname.com') 
AND attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'password_hash' AND entity_type_id = 1);