I've just changed the view of login form to Drupal default view. Now I am not able to log in as administrator.

I have tried to change the password using php .\scripts\password-hash.sh newpwd. I got an hashed password, I used to update the password stored in the database with a SQL query, but still I am not able to log in. I have also cleared entries from flood table.

Any help will be appreciated.

  • Do you have Drush?
    – Gulok
    Aug 8, 2016 at 7:38
  • @Gulok no Im not having drush as Im working in windows Aug 8, 2016 at 7:40
  • Hmnn you can still install Drush in Windows. Gaining access to an account is piece of cake using Drush.
    – Gulok
    Aug 8, 2016 at 8:40
  • Actually what you did were correct. I am not sure why you are still unable to access you account. May I know the exact sql query you did?
    – Gulok
    Aug 8, 2016 at 8:41
  • 1
    @Jimmy Ko I haven't use any hook_form_alter in my custom modules Aug 8, 2016 at 9:12

2 Answers 2

  • Please check if you are using the correct username (you can see that in the database).

  • Try to use the "Forgotten password" function to reset your password

  • Check the last entries of the watchdog table to see if you can get more information from there

  • Check your server logs to see if you get any error there (under Linux this would normally be somewhere under /var/logs).

  • Install drush and use that to very easily log in (https://drushcommands.com/drush-7x/user/user-login/)


if drush is installed,

use drush uli or drush uli uid (you have to copy like this http://YOURSITE/user/reset/1/1470908634/UyfrRRADUusWPoS2wbHZklaBzi1s111JsOeDsJA7Zus ) this is an example for admin(root)

and set password in admin page.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.