[support] Help with login needed

[Metzler, David]

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 at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of Paul Schewietzek
Sent: Friday, October 24, 2008 9:01 AM
To: support at 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/ ]