View source

<seo title="How to reset Drupal admin password" metakeywords="reset Drupal admin password,change Drupal admin password,Drupal admin password reset" metadescription="How to reset Drupal admin password" />

<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. You try to recover the password but also 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''' at the top of the page. 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.
 
 {{#icon: SQL tab.png|SQL tab}}

That's it. Now you know how to get the Drupal admin password reset.


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