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

2007-08-27 / jpoesen

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

So simple. Thanks, occy.