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

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

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

osCommerce - This is a potential security risk - please set the right user permissions on this file

This error is caused when the /includes/configure.php is world writable. To correct this, log...

Gallery2 thumbnails will not show

If you are able to view your pictures in Gallery2 but the thumbnails are not showing or are...

PHPList Email Throttling

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

How do I reset SMF administrator password?

Reset your SMF admin password First login to your control panel, click on "MySQL" then click on...