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

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

How do I reset Mambo administrator password?

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

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

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

Turn off PHP error messages via htaccess

From time to time you may encounter a script which has error messages you do not wish to see....

phpBB: Switching template to default theme

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