How to reset user after being blocked (d7 and works in D8 as well). 1MySQL> delete from flood where identifier=<uid>; To get the uid, search as follows: 1MySQL> select uid, name from users where name like '%NameHere%'\G; Details in https://www.drupal.org/node/1023440 NOTE: Observed to work as well …

1## Generate drupal admin access. 2## 3drush user:create admin --mail="admin.NOREPLY@example.com" --password="admin" 4drush user:role:add "administrator" admin

Go to drupal root, then: 1drush upwd --password="newPassword_here" "the_user" More info in https://www.drupal.org/node/44164

1DROP USER 'yourDBA'@'localhost'

1create database yourDB; 2CREATE USER 'yourDBA'@'localhost' IDENTIFIED BY 'yourPASS'; 3GRANT ALL PRIVILEGES ON yourDB.* TO 'yourDBA'@'localhost'; 4FLUSH PRIVILEGES;