How to change a drupal user's password directly in the db

Drupal 5

update users set pass=md5('your-new-password') where uid = your_user_id;

So simple. Thanks, occy.