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/ ]