View source

<div align=justify>Let's imagine the situation when you have modified your Drupal site and logged out. Next time you are trying to log in but fail. The only way out is to reset the Drupal admin password. 
But how exactly can you do this? 

One of the best ways to change the Drupal administrator's password is to use your '''[[cPanel]] phpMyAdmin''' tool.

Follow the below steps to get your Drupal admin password reset:

'''1'''. Login to '''cPanel => phpMyAdmin''';

'''2'''. Select the Drupal database from the left-side list. You'll be presented with the Drupal database’s tables.

'''3'''. Click on the SQL tab. In the text field enter the following SQL query:

    ''update users set pass=md5(‘NEWPASS’) where uid = 1;''

You can '''replace “NEWPASS”''' with your new Drupal administrative password.
 
That's it. Now you know how to reset the Drupal admin password


'''Note''': phpMyAdmin allows you not only reset the admin password, but also change the passwords for all listed users.</div>

Return to How to reset Drupal admin password.

Retrieved from "http://myidealhost.com/tutorials/How_to_reset_Drupal_admin_password"

Navigation

Search