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

update users set pass=md5(‘your-new-password’) where uid = 1

So simple. Thanks, occy.