How to reset password for Drupal 7 in the MySQL database

First you have to log in to your database, then open the table "users" and find the user you want to amend(ususally the ID = 1 )

then put new sql query

UPDATE users SET name='admin', pass='$S$Drl0vgZ9yuU9uc4JyaTMHxMPriC7q/PsOUOx52fCrVQSTpI/Tu4x' WHERE uid = 1;

This hash  $S$Drl0vgZ9yuU9uc4JyaTMHxMPriC7q/PsOUOx52fCrVQSTpI/Tu4x means password drupal  so than you can easily login with this password and login (usually admin) into the drupal.