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.


Share this page:


Was this article useful? Have any suggestions or improvements to the information?

Also Read

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

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

How do I reset Mambo administrator password?

To reset the password for mambo's admin page simply access the MySQL database by logging into...

Best WP Plugins

The best wp plugins we believe at this time are W3Total Cache, WordFence, Yoast SEO and iThemes...

Gallery2 thumbnails will not show

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

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