Password lost, can't login in my own site
qgil - September 30, 2005 - 06:26
I have lost the password to login to my own drupal installation. Sounds silly, but Mozilla remembered it so well for months that now I have forgotten... and Mozilla too.
This wouldn't be a problem if Drupal could send me a new password, but for some reason it can't because this error message appears after introducing my userID in http://desdeamericaconamor.org/blog/en/user/password
Unable to send mail. Please contact the site admin.
Being myself the site admin, what can I do? :/ Also, I have requested previously new passwords and this function worked. This is a Drupal 4.5.1.
Database
I can't really help you with the mail issue, but if you have direct access to the database, I can help you there.
You need to browse the users table and find the record for your account. Then, in the Password field, input the MD5 sum for the password you want.
If you're using phpMyAdmin with MySQL, this is terribly easy. Go to the proper database, click "Browse" on the "users" table, and click "Edit" on your record. Type your password in plain text in the "Password" row, and under the "Function" column in that same row, choose MD5. Click submit and you're done! :)
Password somehow reset during testing
I was setting up initial users and acceses, then my admin password would not work. I searched the forum and found this explination.
Thank You 75th. Trombone!
druplin4him
just interested to know
how do you generate the MD5 sum password.
(I'm just an interested passerby)
wellsy
orchidsonline.com.au
It is generated during the save
It is converted during the submit process via the MD5 function.
drupl'n4him
Hi! Forgot to say THANKS for
Hi! Forgot to say THANKS for helping me. This was the way I could use to recover my admin permissions.
thanx i figured it out
i figured it out
This is sooo helpful...
Thanks!
Lsabug
cannot login on local install
Same here...
I installed Drupal without a problem before, but installing the Devel (spell check wants to change it to "devil"... ;) plugin broke everything and I couldn't figure out how to fix it so I deleted the Drupal install + database to restart with a fresh setup (I wasn't very advanced in dev process thankfully...) but with this fresh install, when I created the 1st admin account, instead f automatically logging me in like the first time, I got a "denied access" message once redirected to admin area. I tried the MD5 hack explained on here but now it doesn't do anything when I try logging in, no error message, just refresh the page as if nothing happened...
Drupal 5.1, MAMP 1.6
Any pointer in the right direction much appreciated!! Thx
worked for me
Thanks dude, built a site for some friends that have a metal band and shelved it until ready to deploy. Did so today and couldn't remember the password plus the email address used was incorrect. thanks a million.
password
hey i tried the server2go, its great to have a view of the web sites when you dont have a server, or your servers access is limited, anyway, this little thing called server2go, have an Apache server, and support Drupal, but when i run the drupal, i create the first account, but it doesnt have a email service, so the mail will never be send, and i want to know if any way to log in whit out that email? i made that to see the databse whit the phpMyAdmin, but doesnt works... so if anybody know about please let me know
Thanks
its works... but not at all...
i did that whit the phpMyAdmin but.... when i click on submit, i see the password change, but in the same way (its look like 2D344gdsfdf434345....), and then when i try to log in, i write my userid and password and only accept it, but never log me in... do i have to change anything or what else do i have to do???
Lost Password
Thanks this really worked for me!
thankyou thankyou thankyou
i have read too many pages trying to get into my offline site, with all the answers assuming i didn't already know about accessing through the '/user' page.
anyways, time to stop stressing and to start working on the site.
/grateful person
Try this
It looks like you disabled the login block.
1.)Go to your www.yoursite.com/drupal_install/user/login and you will be presented with the login screen.
2.) Click on the 'request new password' tab and in the screen that follows, type in either your admin username or email address and click the 'Email new password' button.
You will receive your new password at the email address you mentioned when you set up the site.
YOW!
Thank you ever so much. I am bookmarking this for sure..
does anyone know if this
does anyone know if this process should work on drupal 5 as well? I have tried it and can't get logged in. I don't believe I forgot my password anyway; don't even think i mis-typed it when I created the account. What is interesting is that when I log in with my user and pass typed correct, the page just "refreshes" and bring me right back to the login page. When I log in incorrectly, I get a message saying login is incorrect.
I was poking around the database and the weak table between user and role doesn't have any data in it. I did create a record in that table to match my admin account with the admin role. Still....nothing.
Any ideas?
try from a browser other
try from a browser other than the one you are using. to see if its a cross browser situation and help diagnose.
I've the same problem
I've the same problem at my home with a Kubuntu Linux box, while in my production site with a FreeBSD does NOT fail, in both cases I'm using the same firefox browser so I think it's not a matter of browsers.
does not work on my 5.1 installation
I tried to reset my Admin password as described here: http://occy.net/node/122
After resetting, I stil cannot log in.
switch from (old) Konqueror to (latest) Firefox
I use Konqueror during development, and swiching to Firefox seems to solve the problem. For more info: have my box been hacked?
Having the Same Problem
I'm having the same problem with a 5.1 installation. I can see that the password has been changed, but I still cannot login as the admin user. Has anyone figured out why this is and how to fix it?
lost admin password
Hi,
I don't have phpMyAdmin so how do I access the database with the command line? The IT guy that set it up left, and I don't even know the db name or password. The email says its sending, but it never shows up. Any help would be greatly appriciated. Thanks.
=-=
open your sites/default/settings.php file find the line $db_url and in that line you will see your db name and password.
I can't believe you lost and
I can't believe you lost and mozilla too. No worries, next time you won't.
Sometime back I have read on this Linux blog about how your firefox can remember passwords for different sites and you can access it through one master pass. Isn't that cool?
You might want to read it...
http://blog.webgk.com/2007/09/master-password-in-firefox-remember.html
With Regards,
Sam
75th Trombone thanks for
75th Trombone thanks for that phpMyAdmin trick. Operating in offline mode and my cookies got cleaned and I couldn't remember my pass. Worked a charm. Thanks again.
resetting password via command line
This applies to MySQL. If you need to reset your admin password via SQL using the command line, btw, don't type , press the key ;):
#mysql -u username -p -D databasename<enter>
enter password at password prompt
mysql>UPDATE users SET password = md5('newpassword') WHERE uid = 1;<enter>You'll see:
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings:0
to exit mysql.
mysql>quit<enter>Make sure you include the WHERE clause. Make sure the password you use is a secure one.
Log back into your site using your first user account and the newpassword.
You can do the same via a MySQL web client or gui.
It's working
Thank you Jscoble it is really working
mysql> update users set pass=md5('admin') where name = 'admin';
Thanks again
Accessing Site When Admin PW Lost
75th Trombone wrote:
Followed this good instruction. Still unable to log in with previously set password. Just to be sure, I had copied the long password string that was existing in the phpMyAdmin password column. Restored it and then used that long string to log into my site which also uses Apache locally. Worked like a charm.
I may possibly have confused my keychain by developing two separate local sites and using the same passwords, even though each site has its own name. localhost/sitename and localhost/othersitename. But it is working now.
Thanks much, 75th Trombone
Can Administer Site
Quick question.
I promoted a page to front page and since then when I click on "Administer" nothing happens. What could have caused this?
P.
I delete "My Account" my admin account for my website
I use Drupal to setup my website and by mistake i delete my admin account and what should i do to get access to my website buliding process.
=-=
read: http://drupal.org/node/100252
where there is some sql to readd the addmin user directly into the DB
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )