password reset – Blog

How to reset admin password using drush

March 27, 2018 at 1:54 pm (last edited October 23, 2019 at 5:27 pm)

If you’re on Drupal 7 use https://github.com/drush-ops/drush/archive/7.x.zip to install Drush

drush upwd --password="jd938pls@l$4401ks" "admin"

MySQL command line:

UPDATE users SET pass = MD5('jd938pls@l$4401ks') WHERE uid=2;

Drush can generate a one-time login link.

drush uli

Then replace “default” with your website URL

To get URL with your domain name instead of default, try it as the following:

drush uli --uri=yourdomainnamehere.com

January 2, 2015 at 3:53 pm (last edited January 2, 2015 at 4:37 pm)

Means you have a root previlegies:

mysql database_name;

mysql> update jos_users set password = MD5("strong_password_here") where id = 111;

id = 111 – must match to the account for which you want to reset password

Done!

October 3, 2014 at 7:57 pm (last edited February 20, 2015 at 3:45 am)

Start mysql server with skip-grant-tables

mysqld_safe --skip-grant-tables

mysql

use mysql;
update user set Password=PASSWORD('new-password') where user='root';
flush privileges;

Done!

Now kill mysql processes and restart your mysql server… Read the rest