Search code examples
drupal-7

Can't reset Drupal admin password

I need to reset my Drupal site's admin password and I can't user the email reset because the admin email doesn't exist.

I followed the directions here: http://www.ostraining.com/blog/drupal/reset-your-drupal-admin-password/

I ran the SQL: UPDATE dr_users SET pass = md5('newpassword') WHERE uid = 1; - no luck

I also tried entering a password into the users table manually in plain text. - no luck

At this point I'm not sure what the problem is.

The only thing I can think of, and I can't see why this would be it, is that I have a browser open with Admin logged in using the old password. This seems to be a hint to my problem as I would expect that on page refresh I would get logged out as the password has now changed.

Solution

  • try to update the admin email via mysql, then have drupal email you the password reset.
    To see what you have now, you could look at the output from SQL 

    SELECT * FROM dr_users WHERE uid = 1;