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.

  • 153 Users Found This Useful

Was this answer helpful?

Related Articles

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

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

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 do I reset Joomla administrator password?

How to reset Joomla administrative password Start by logging into your control panel. Once...

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