How to reset the admin password in Drupal

To change the administrative password for your current Drupal installation you should:

1. Go to your cPanel -> Databases box -> phpMyAdmin;
2. Select the database which Drupal use from the drop-down menu on the left.
4. Click on the SQL tab.
5. In the text field on the page type the following text:

update users set pass=md5('NEWPASS') where uid = 1;

where "NEWPASS" is your new administrative password. Then click on the GO button and if no errors present, the Drupal password should have been changed.

  • 155 Users Found This Useful

Was this answer helpful?

Related Articles

Joomla Warning: Parameter 2 to frontpage()

The error: Joomla Warning: Parameter 2 to frontpage() can occur when you use an out-dated install...

How do I reset Zen Cart administrator password?

First login to your control panel with us, then click on the "phpMyAdmin" icon. Click the...

Joomla Strict Standards: Declaration of JParameter::loadSetupFile() should be compatible with that of JRegistry::loadSetupFile()

For this particular error we have found a work around which works until Joomla corrects their...

Moodle: Notice: Only variable references should be returned by reference

Notice: Only variable references should be returned by reference The issue is with Moodle...

Tiki Wiki: Notice: Only variable references should be returned by reference

You can find the latest version of ADODB here. To modify the function to not return a...