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

PHPList Email Throttling

As we are primarily a website hosting provider we limit email sending to 150 emails per hour. If...

Coppermine Gallery cannot create thumbnails

If Coppermine Gallery will not resize photos and shows an error please try the following... In...

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...

How to turn off magic quotes gpc for Joomla 3

Add the line "php_flag magic_quotes_gpc off" to the .htaccess file. If one does not exist create...

phpBB: Switching template to default theme

To change your phpBB theme back to the default which may be necessary when upgrading, log into...