09 Apr, 2010

How to change root admin user password in Drupal ?

In order to reset the root or superadmin password on a drupal system, login into the database by looking at the
settings.php
. You can use phpMyAdmin or any other MySQL utilities like SQLYog, or MySQL command line. Run the following query to reset the password.
UPDATE users SET pass = MD5('password') WHERE uid = 1 
The user id of administrator is always 1. Password field in drupal is stored as MD5 of the actual string password. So running the above query would set your password as password of the superadmin user.
Comments (1) Post a comment
  • Thank you - works brilliantly

    Thank you, thank you, thank you!

    Oh, and thank you!

    Best
    Pam

    By mcpixelchick on 22 Jul, 2010 Reply
You may also like



Email Newsletter
Email:
Popular Posts
Recent Posts
Tags
Random photo
Rainbow appearence near Havelock Island Rainbow appearence near Havelock Island in Havelock Island Andaman
On Facebook
Recent Comments


digitalpbk