{"id":176,"date":"2012-08-07T10:30:37","date_gmt":"2012-08-07T10:30:37","guid":{"rendered":"https:\/\/satyadeep.in\/blog\/?p=176"},"modified":"2020-11-04T17:19:21","modified_gmt":"2020-11-04T11:49:21","slug":"drupal-7-password-reset","status":"publish","type":"post","link":"https:\/\/satyadeep.in\/blog\/drupal-7-password-reset\/","title":{"rendered":"Drupal 7 Password Reset"},"content":{"rendered":"

All of us have at one time or another forgotten our Drupal Installation password. After you\u2019ve tried all those likely combinations, you still cannot login in. Isn\u2019t that frustrating?<\/p>\n

Here\u2019s a simple way to reset the password assuming, you have access to the associated database.<\/p>\n

First up, if you have shell access to your Drupal installation folder, then  open up the shell and browse to the Drupal root folder.<\/p>\n

Next run this built in Drupal script to create the new password hash php .\\scripts\\password-hash.sh \u201cnewpassword<\/em>\u201d Replace  newpassword <\/em>with the password that you\u2019d like to set. Do NOT exclude the double quotes. Copy the password hash that you get after running the above command.<\/p>\n

Resetting the password in the database<\/strong><\/p>\n

Step 1<\/strong> Open phpMyAdmin and open the database associated with your Drupal Installation. Within the Drupal database, browse to the table named \u201cusers\u201d<\/em>.<\/p>\n

Note: If you had setup a database prefix while installing Drupal, the table name will be \u201cprefixname<\/em>_users\u201d.<\/p>\n

Step 2 <\/strong>In the \u201cusers\u201d table , find the row that has the admin user (or any user whose password needs to be reset) and click on \u201cEdit\u201d on that row.<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

Step 3<\/strong> You\u2019ll get a screen with several rows and columns. Find the row that has \u201cpass\u201d and in the \u201cValue\u201d Column of that row, delete the current value and paste the password hash (not the actual password) that you generated in the step above .<\/p>\n

Step 4<\/strong> After that click on the \u201cGo\u201d button to save the new password.<\/p>\n

 <\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

You can now login using your new password. Hope this post was helpful<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

All of us have at one time or another forgotten […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[18],"tags":[19,20],"class_list":["post-176","post","type-post","status-publish","format-standard","hentry","category-drupal","tag-drupal-2","tag-password-reset"],"_links":{"self":[{"href":"https:\/\/satyadeep.in\/blog\/wp-json\/wp\/v2\/posts\/176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/satyadeep.in\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/satyadeep.in\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/satyadeep.in\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/satyadeep.in\/blog\/wp-json\/wp\/v2\/comments?post=176"}],"version-history":[{"count":6,"href":"https:\/\/satyadeep.in\/blog\/wp-json\/wp\/v2\/posts\/176\/revisions"}],"predecessor-version":[{"id":219,"href":"https:\/\/satyadeep.in\/blog\/wp-json\/wp\/v2\/posts\/176\/revisions\/219"}],"wp:attachment":[{"href":"https:\/\/satyadeep.in\/blog\/wp-json\/wp\/v2\/media?parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/satyadeep.in\/blog\/wp-json\/wp\/v2\/categories?post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/satyadeep.in\/blog\/wp-json\/wp\/v2\/tags?post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}