How to change drupal password on localhost (xampp)?

Question

I have a Drupal website on my computer.

I forgot its password and I don't know how to recover it.
I can't send emails in my computer or localhost.

I read a lot of webpages about resetting the password in Drupal on localhost, but not working.

Why don't you configure `XAMPP` to send emails? Look at this answer: http://stackoverflow.com/a/18185233/4193263 — ByteHamster, Apr 04 '15 at 09:12

score 1 · Accepted Answer · answered Apr 04 '15 at 19:59

1

To reset you password use this command:

UPDATE users SET pass='$S$Cd059Vsxc8berFeg6hspaa7ejx2bSxyUisvCbT4h9o8XIgSUtPKz' WHERE uid=1;

This password is: password

To sent emails from XAMPP, use SMTP module: https://www.drupal.org/project/smtp

answered Apr 04 '15 at 19:59

Adonai Diófanes

26
2

score 1 · Answer 2 · answered Apr 06 '15 at 07:27

Just create a file "new_password.php" (or with any other name) inside your drupal folder and access it using browser. It will generate one way encrypted hash password for you.

<?php
  define("DRUPAL_ROOT", getcwd());
  require_once DRUPAL_ROOT . "/includes/bootstrap.inc";
  drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
  require_once "includes/password.inc";
  echo user_hash_password("123456");
  die();
  menu_execute_active_handler();
?>

When you run this code in browser it will show you hash password like

$S$D95YW4EejaUDPq5nZ7Z2Ljx1Ud4wlN1iTMQdAKton70JcQpCZmrG

Now you need to update your database table using above hash. Open your database using PHPMyAdmin or Workbench and run the below query.

UPDATE users SET pass = '$S$D95YW4EejaUDPq5nZ7Z2Ljx1Ud4wlN1iTMQdAKton70JcQpCZmrG' WHERE uid = 1;

Now you can access drupal using username as "admin" and password as "123456". Make sure you update password after login to the admin.

Haemalatha · Answer 3 · 2015-04-07T14:52:00.547

1

You can reset the localhost password using the drush

drush upwd --password="yourpassword" username

for eg: drush upwd --password="sweety" pragya

edited Apr 07 '15 at 14:52

answered Apr 07 '15 at 14:45

Haemalatha

11
3

score 1 · Answer 4 · answered Apr 09 '15 at 11:45

There is one more way to reset password using drush . Just type drush uli. This will give you one time password reset url for Admin.

Something like http://default/user/reset/1/1428579639/O1Rs12HxYZV7rrMUR7xuXhg9RDvsk9OFZ1-nVCoSVWU

Replace default with your actual drupal URL and paste it in browser it will ask for new password.

How to change drupal password on localhost (xampp)?

4 Answers4