my blog

Nightmare of nightmares, you have forgotten your user 1 account login for your Drupal Site, and for some reason the password retrieval just will not work. How do you get back into your site administration? If you have database access, the answer is simple.

update users set pass=md5('PASS') where uid = 1;

This sets your user 1 password to PASS .