This week one of our clients was unfortunate enough to have an automatic update of a plugin fail about 1/2 way through. This caused their wp-admin section to become unusable. When they contacted us we weren’t privy to the details of the failed plugin upgrade so we just assumed they lost their password and couldn’t get it back. Sending a recovery email wasn’t working so we went ahead and reset it via phpMyAdmin.
To reset your WordPress password via phpMyAdmin you need the directions below and it should take you less than 5 minutes.
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.