The way I have been successful whacking the admin password when I've needed to is Update users set pass=null where uid=1;
This means admin no longer has a password, and you can leave it blank to login.
Then login without a password and change it immediately.
Dave
-----Original Message----- From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Paul Schewietzek Sent: Friday, October 24, 2008 9:01 AM To: support@drupal.org Subject: Re: [support] Help with login needed
Am Freitag, den 24.10.2008, 08:49 -0700 schrieb Min Yan:
Hi there, I cannot login to my Drupal site. I tried to request a new password using my email address, and got no reply.
Is an SMTP server correctly configured in php.ini?
And I also try the following, UPDATE `users` SET pass = MD5('newpwd') WHERE uid=1; On
my MySQL DB,
then try to login, but still failed, (I use PC for my site). Any help
is greatly appreciated!
I don't know anything about the database structure of Drupal, but I think you're strongly supposed to NOT do any SQL directly in Drupal's DB.....
Min Yan
- Paul
-- [ Drupal support list | http://lists.drupal.org/ ]