I put an old site on my new machine and got it up and running, except for clean URLs. The login creds in my notes didn't work so (after a few attempts) I used mysql via drush to change the password, no dice. I also checked to be sure I had the correct user1 name and it is. Though all this, the account got blocked because of all the login attempts, which I also tried to remedy via drush, however it alert still says the account is blocked and I still can't login. I don't know where to go from here.... please help.

  • Have you tried the drush user-login command? Usually works nicely. – greg_1_anderson Dec 24 '12 at 6:17
  • Directly go into database and make some changes on user and variables table manualy – Mohammad Ali Akbari Dec 24 '12 at 6:46

well you can first

drush upwd --password="yourNewPassword" UserName

to reset your password.

then you would need to remove the attempts so you can try to login again, you need to truncate the table flood.

  • In case anyone else ends up here, and is newbier than me... the truncate command is done from the mysql prompt: mysql -u root ... USE sitesDatabaseName ... TRUNCATE TABLE flood -- Although I'm not sure this did anything since the response was Query OK, 0 rows affected (0.10 sec) – The Real JC Dec 24 '12 at 17:26
  • Truncating your flood table will clear the number of attempts of log in lock. So if you tried to log in unsuccessfully for more than 5 times you will be locked outside for a significant amount of time even if you enter the right user/password. – saadlulu Jan 21 '13 at 6:48

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.