Change the admin user password in drupal

UPDATE users SET pass = md5('The password!') where uid=1;