m |
m |
||
Line 1: | Line 1: | ||
− | <seo title="How to reset Drupal admin password" metakeywords="reset Drupal admin password,change Drupal admin password,Drupal | + | <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. |
− | + | ||
− | <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 | + | Follow the below steps to modify your Drupal admin password: |
'''1'''. Login to '''cPanel => phpMyAdmin'''; | '''1'''. Login to '''cPanel => phpMyAdmin'''; | ||
Line 14: | Line 12: | ||
'''3'''. Click on the '''SQL tab''' at the top of the page. 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;'' | |
You can '''replace “NEWPASS”''' with your new Drupal administrative password. | You can '''replace “NEWPASS”''' with your new Drupal administrative password. | ||
Line 20: | Line 18: | ||
{{#icon: SQL tab.png|SQL tab}} | {{#icon: SQL tab.png|SQL tab}} | ||
− | That's it. Now you know how to | + | 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> |