By AngelicLight on

Hi, there,

I'm ruing a basic local host setup for now and stupid me, forgot to write down the id=1 password.

I tried the SQL statement from phpmyadmin of "update users set pass=md5('password') where uid = 1;" with the password I chose, and pypmyadmin successfully rant he statement, but the password is not taking.

Any other thoughts or ideas?

Thanks and sorry for the confusion or trouble,

- Paul

⋅ Categories: Drupal 7.x

Comments

nevets’s picture

nevets commented

Have you tried the request a new password feature?

AngelicLight’s picture

AngelicLight commented

How do I do that on a localhost WAMP server where I'm not running a mail server?

nevets’s picture

nevets commented

If you have no mail sever you can not request a new password.

jamesoakley’s picture

jamesoakley
Primary language English
Location North Yorkshire, UK
commented

Install another Drupal instance, giving ID=1 the password you want.
Then use phpMyAdmin to set the password for the installation you're locked out of to be the same as the password for the installation you knew what you were doing with.

This signature is currently blank
progpapa’s picture

progpapa commented

Hope this helps:
http://drupal.org/node/992400

the user_hash_password() with require_once worked for me.

Maryam Sakhaei’s picture

Maryam Sakhaei commented

i want to recover my username and password in localhost drupal

gisle’s picture

gisle
he/him
Primary language Norwegian Bokmål
Location Norway
commented

https://wikihandbooks.com/drupalnewbies/ch18_resetpw.html

- gisle