How to change wordpress admin password from phpmyadmin using sql

So you need to login to your phpmyAdmin from your hosting and then you need to open the wp_user table ( you may need to change the prefix based on your wordpress table configuration .

Here i have tried to change the password of user “admin” to “abcdef@@”

Here is the screenshot

SELECT ID FROM `wp_users` WHERE `user_login` = 'admin';
UPDATE `wp_users` SET `user_pass` = MD5('abcdef@@') WHERE `ID` = 1;