Removed default login by mistake and logged out. Can't login

Question

I made the mistake of removing the user login block through the web interface, and logged out.

Now, I don't have the login interface anymore. Does anyone know how to solve this or is re-installing the only solution?

Furthermore, when I access example.com/user, the log-in form is shown, but it doesn't accept my credentials anymore.

---

I think I have found the "issue": The login page on mysite/user is the default login page for mysite; however, the default login block that is displayed on the front page is the login for the Drupal 7 web interface. These two are completely separate, that is why my credentials weren't working on mysite/user.

So in conclusion, if you removed the default login block and logged out of the drupal 7 web interface, then you are in troubles.

Please correct me if I'm wrong.

Answer 1

Jimajamma's answer is correct, but the real question here is: How do I hack a new password for user 1, given that I lost/corrupted/forgot my old one?

If you haven't turned off user registrations, create a new user. Now you have a password hash in your database for a known password. You could come up with some SQL to move this hash to user 1's password column, couldn't you? :-)

Then log in, change the password if you need to, delete the user you created, etc. And write it all down. :-)

Answer 2

You can reset the password in the database. Make sure that you hash it correctly using /scripts/password-hash.sh (or manually if you're comfortable). Just as an example...

1. cd /site/root

2. ./scripts/password-hash.sh "test password goes here"

   This should return something like:

   password: test password goes here hash: $S$Dq18FZ8uh1pMdNYE3YMw3wWytBULp8a54T/ixwnrn3IyeQL/bopi

3. drush sqlc

   This step uses drush to connect to your database. If you don't use drush, connect to your database in whichever way you are comfortable. I suggest trying drush. It is very powerful and will make many problems easier to solve and solutions easier to realize.

4. UPDATE users SET pass='$S$Dq18FZ8uh1pMdNYE3YMw3wWytBULp8a54T/ixwnrn3IyeQL/bopi' WHERE uid=1;

You should then be able to log in as user 1 using password test password goes here.

Answer 3

Try http://www.yoursite.com/user.

Answer 4

I dont know the reason why your credential are not working.But you can update password through the phpmyadmin. To reset your password,

1. Go to users table in your db
2. find the username root and click edit for edit that row
3. Then in the password field give your new password
4. And DON'T FORGET to use MD5 function to encript your password

If the above way is not easy to you then,

<?php 
   db_query("UPDATE users SET pass = MD5('newpwd') WHERE uid=1"); 
?>

1. create a page and set the text format as PHP code
2. Then paste the above code with replacing new password and click preview or save
3. It will update the admin user password Here is the code

Answer 5

I had the same problem today , and I solved it by updating some fields in drupal's database. I went to Block table in drupal's database. and executed this query :

"update block set status = 1 , region = 'any-visible-block-name' where theme = 'current-theme-name' and module='user' and delta='login'; "

then I returned to my website, and the authentification block appears in 'any-visible-block-name' that I specified in previous query.

Good luck and hope it help you :)

Answer 6

I solved the same problem by reseting the default theme to Bartik using drush:

• first, i navigated to /var/www/website_folder and run
  drush vset theme_default bartik
• after that, i went to my website page and manage to login as admin
  
• than went to Appearance and set back old theme (the one that i was using when problem happend) and in Structure -> Blocks enabled User login block
  

That worked for me.