Drupal

How to reset drupal admin password with sql-query?

Rest Drupal Admin Password

To reset drupal admin password when you lost it and email notification could not work mostly on localhost, then you can reset it with sql-query. For this you have to generate a password hash from following command.

Execute following command from command line, in Drupal root directory.

php .\scripts\password-hash.sh yourpassword

Note: If you get error that php is not recognized command then you need to set environment variable for php.

Note: change “yourpassword” with your desired password.

After this; execute the following query on drupal database.

UPDATE users SET pass = ‘$S$DkKBntGJ8OAHCyu.H9EYYRvokfk.Y8QjvpHI5FML1B7Okg0u970d’ WHERE uid = 1;

That’s it. Now you can login in your drupal admin with new password.

websourceblog

ReactJs, NodeJs, Amazon Web Services, Symfony, Laravel, CodeIgniter, Zend Framework, WordPress, Drupal, Magento, Angular

Recent Posts

How to Add an Addon Domain in GoDaddy with Web Hosting Deluxe

Add an Addon Domain in GoDaddy with Web Hosting Deluxe (Step-by-Step Guide). If you are…

4 weeks ago

Developing a RESTful API with Node.js, Express.js, MongoDB, and TypeScript

The ability to create reliable APIs is essential in today's web development environment. I'll show…

3 months ago

XML in REST API response and SOAP XML.

The difference between XML that we get in response to any REST API and XML…

9 months ago

How to install and configure Apache2 on WSL2?

I hope you already have WSL2 installed and enabled. So, setting up Apache2 on WSL2…

1 year ago

How to install NVM on Windows?

Install NVM on Windows Node Js is a JavaScript runtime environment used widely in today’s…

1 year ago

How to reset WSL 2 user’s password?

You can easily reset WSL 2 users' password, by just following the following steps. Open…

1 year ago