Drupal Interview Question:

How can I reset my Drupal admin password?

Submitted by: Muhammad

Login to cPanel -> Databases box -> phpMyAdmin;
► Select the Druapl database folder from the left navigation bar. The page will refresh and and the Drupal database's tables will be displayed on it.
► Click on the SQL tab.
► In the text field write the following SQL query:
update users set pass=md5('NEWPASS') where uid = 1; where "NEWPASS" is your new Drupal administrative password.
Click the GO button to submit the query. If the query is executed correctly and no errors are displayed then you should be able to login with the new password.
Submitted by: Muhammad