Search results for:
Table of Contents
If you have lost your Drupal admin login, You can use the following methods to reset your administrator password.
Log into PhpMyAdmin, either through your control panel or by visiting your PhpMyAdmin URL.
In the left-hand panel of PhpMyAdmin, click the Drupal database name.
At the top of the page, click the "SQL" tab.
Run the following SQL statement by typing the following in the query text box. (Swap out NewPassword for the password you would actually like to set.)
UPDATE users SET pass = MD5( 'NewPassword' ) WHERE uid = 1;
You should be able to log in to Drupal as the administrator with the password you just set.
Written by Hostwinds Team / October 7, 2019