> UPDATE users SET password='';
That would be an extremely bad idea. Never set pass to empty on Drupal 6 sites.