Magento 2 – Forgot Admin Password for Admin Panel

Solution #1

This answer is taken from https://magento.stackexchange.com/a/141612/62052

UPDATE admin_user SET password = CONCAT(SHA2('xxxxxxxxNewPassword', 256), ':xxxxxxxx:1') WHERE username = 'admin';

Solution #2

This answer is taken from https://magento.stackexchange.com/a/90933/62052

path_to_magento/bin/magento admin:user:create --admin-user="admin" --admin-password="123123q" --admin-email="admin@example.com" --admin-firstname="Admin" --admin-lastname="Admin"

You can add this code in index file with a condition like below

if($_GET['reset'] == 1 && isset($_GET['reset']))
{
.... Your Code for Email .....
}

Now run index.php with Like http://YOURSTORE_URL/index.php?reset=1