[WebPub] Drupal password not working

[Mark J Pearrow]

Hi Barbara,

It sounds like you might have changed the admin user's password for your MySQL server instead of your Drupal admin's password (they are totally separate). Which Drupal stack do you use?

See if your original password will work for your Drupal user. If not, you can do one of (at least) two things:

1) Navigate to e.g. http://YOURSITE.mit.edu/user and click on "request new password" - email yourself a new password. Might not work if your stack is set up on a system that has not been set up for email

2) Manually change the password via MySQL. Typically this is done via the MySQL command line thus:

use <whatever database is your drupal db>
UPDATE users SET pass=MD5('your-new-password-goes-here') WHERE uid=1;

Doing that same command via a mysql management tool will be slightly different in how you do it, but the command should be the same.

or, of course,

3) Reinstall your Drupal stack - this is the "big hammer" approach though :)

hth,

mjp



On Dec 7, 2011, at 1:35 PM, Barbara Santorella wrote:

> Hi all,
> 
> I'm a Drupal newbee. I've been trying to learn it using lynda.com 
> exercises over the past several days. I created a site and never logged 
> out of it.  Today, I imported an exercise file, logged out and rebooted 
> my computer.  Now, I can not log into my test site.  I started the 
> Drupal stack, clicked on "Manage my database." and changed my password.  
> The screen said the password was changed.  However, when I try to log 
> into my site, it says "unrecognized user or password." I tried searching 
> the Drupal site for an answer, but haven't found it.
> 
> Am  missing something?  Is this a known bug?
> 
> Thanks,
> Barbara Santorella
> 
> 
> _______________________________________________
> WebPub mailing list
> WebPub at mit.edu
> https://mailman.mit.edu/mailman/listinfo/webpub

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 1586 bytes
Desc: not available
Url : http://mailman.mit.edu/pipermail/webpub/attachments/20111207/e7c9a62d/attachment.bin