Earlier this week we were presented with the challenge of doing some work on a Drupal site. The issue with this was that the client did not know the administrator username and password. After spending a few minutes poking around the database we were able to get the following commands to work.
To recover your Drupal username type this into the SQL section of PHPMyAdmin:
SELECT name FROM users WHERE uid = 1;
To recover your Drupal password type this into the SQL section of PHPMyAdmin:
UPDATE users SET pass = md5(‘password’) WHERE uid = 1;
When doing the password change just change the password to whatever you want your new password to be.
If you have any questions feel free to contact us and we’ll be glad to assist you in changing your Drupal administrator password.