How to reset Drupal admin password

m
m
 
Line 1: Line 1:
<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 your Drupal admin password.  
+
<seo title="How to reset Drupal admin password" metakeywords="reset Drupal admin password,change Drupal admin password,modify Drupal password,new Drupal password" 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?  
 
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.
+
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:
+
 
 +
Follow the below steps to modify your Drupal admin password:
  
 
'''1'''. Login to '''cPanel => phpMyAdmin''';
 
'''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.
+
'''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:
+
'''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;''
+
''update users set pass=md5(‘NEWPASS’) where uid = 1;''
  
 
You can '''replace “NEWPASS”''' with your new Drupal administrative password.
 
You can '''replace “NEWPASS”''' with your new Drupal administrative password.
 
   
 
   
That's it. Now you know how to reset the Drupal admin password
+
{{#icon: SQL tab.png|SQL tab}}
 +
 
 +
That's it. Now you know how to modify the Drupal admin password.
  
  
 
'''Note''': phpMyAdmin allows you not only reset the admin password, but also change the passwords for all listed users.</div>
 
'''Note''': phpMyAdmin allows you not only reset the admin password, but also change the passwords for all listed users.</div>

Latest revision as of 12:39, 25 January 2012

rss feed for my website