Forgotten your Drupal account password

When the Drupal account password for user 1 (the administrator) is lost and the email notification doesn't work, it is possible to set the password via a database query.

Execute the following query on the Drupal database:

Of course, change 'newpwd' to the desired password.

To execute this query it will be necessary to login to the database. This is typically done through the command line or through a GUI interface such as phpMyAdmin.