Found yourself in a scenario where your trying to access a hosted WordPress site, but either can't remember or don't have access to the password and email address? This article will help you regain access to the admin area.
In this article we're going to look at how you can reset a WordPress password via the database using phpMyAdmin or command line.
If your server or cpanel has phpMyAdmin installed then this should be nice an easy. Follow the steps below to reset your one of your WordPress admin user passwords:
If you don't have phpMyAdmin available to you, but can
mysql -p -u yourusername
SELECT * FROM wp_users;
UPDATE wp_users SET user_pass = 'longmd5hash' WHERE ID = 1;
Either of the two methods above should have you back up and running with admin access to your WordPress site.