Reset User 1 (root, or admin) user in Drupal

In case password notification by email doesn’t work, we can change the “root” or “User 1” password in Drupal using an SQL query. Connect to the database and run the following:

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