• rss_16
  • facebook_16
  • twitter_16

How to Change Drupal Administrator Password


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.

About Ryan Gatto

Project manager extraordinaire with hundreds of website designs created and managed from concept to execution. Results-oriented leader dedicated to client success through all relevant media channels, creative marketing and advertising design. Keen branding eye with the ability to generate creative concepts that deliver results based on client goals and input.