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

Coppermine Gallery cannot create thumbnails

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

How do I reset Mambo administrator password?

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

How do I reset Zen Cart administrator password?

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

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

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