Changing WordPress Password With MySQL Query
By Wordpress has a built in password recovery tool that works by emailing you a link. To recover your password this way, click Forgot your password on the login page and type the email associated with your account.
Sometimes though we will find the need to manually reset the password with MySQL. To do this, first connect to MySQL and login by running this command:
mysql -u root -p
using my_wp_db_name;
UPDATE wp_users set user_pass = md5(12345678) where user_email='my@email.io';
Make sure to change the email and password in the above command. Make sure you leave the md5 call on your plain text password(in other words just replace 123456789 with your desired password)