password recovery for drupal

Question

i forgot my drupal user id and password. Is there any way to recover it

Answer 1

http://example.com/<path-to-drupal>/user/password should bring you to a page where you can request a reset/new-password.

Edit: The above path applies if you have 'clean URLs' enabled, if not use http://example.com/<path-to-drupal>/?q=user/password

Answer 2

If you don't have access to the email (or want to bulk-update the passwords) you can update the database with a query like:

UPDATE users SET pass = md5('NEWPASSWORD') WHERE name = 'admin'

Answer 3

Does anybody know how to do lyricnz's trick in D7 ? It looks like 7.x got a more tricky pass storage scheme.