Forgotten your Drupal account password

When you forgot your Drupal account password for user 1 (the administrator) and the email notification doesn't work, you can still set the password via a database query.

Execute the following query on your drupal database:

UPDATE `users` SET pass = MD5('newpwd') WHERE uid=1;

Of course, change 'newpwd' to the password you want.

 
 

Drupal is a registered trademark of Dries Buytaert.