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 '16 at 7:38
  • @Gulok no Im not having drush as Im working in windows Aug 8 '16 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 '16 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 '16 at 8:41
  • 1
    @Jimmy Ko I haven't use any hook_form_alter in my custom modules Aug 8 '16 at 9:12
  • 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, privacy policy and cookie policy

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