Reset Wordpress Password via SQL

if you have access to the mysql database you can recover account access by resetting the password using the following

SELECT ID, user_login, user_pass FROM wp_users;
UPDATE wp_users SET user_pass = MD5('NEWPASSWORD') WHERE ID=1 LIMIT 1;