How to change Admin password for WordPress

[Noturns]

To be clear i don't mean the wp-config.php admin password for mysql but the wordpress Plesk admin account that is associated with Log in button

For some reason my user has lost his password and is not able to use the Wordpress forgot password - wizard form at the page where you normally logged on.

I have tried to reset the password via Change Account on the WordPress Installation
and it came back with the message

Error: Unable to find the specified administrator account in WordPress. Specify the username of your administrator's account in WordPress. This account will be associated with Plesk.

I have tried to add another admin via MySQL with this http://www.wpexplorer.com/reset-wordpress-password/ and that didn't work either.

 

[Chris1]

Hello,

You can edit the existing admin password in the users table in the sql database. Ensure you select MD5 from the drop down when saving your new password.

 

[Noturns]

Hello,

You can edit the existing admin password in the users table in the sql database. Ensure you select MD5 from the drop down when saving your new password.

I have tried with following SQL code

UPDATE `databasename`.`prefix_users` SET `user_pass`=MD5('********') WHERE `prefix_users`.`ID`=1;

And if i do refresh and empty my browser cache i see this

You do not have sufficient permissions to access this page.


And
for some reason i cannot over rule the previous admin username or password via Plesk
It comes up with Error: Unable to find the specified administrator account in WordPress. Specify the username of your administrator's account in WordPress. This account will be associated with Plesk.

 

[abdi]

If you have ever lost or forgot your password to access the WordPress dashboard, it can be very frustrating. Luckily WordPress provides quite a few options for changing or resetting your WordPress password. More how to here-in below:

http://www.inmotionhosting.com/support/website/wordpress/resetting-your-wordpress-admin-password

 

[Noturns]

I think the problem began after this wordpress site was imported from a old Plesk server with different Admin credentials.

Unfortunately i have read your reply too late as we have recreated the wordpress site from scratch

@abdi my apologizes for not following on your advise, i will bookmark it for the next time it happens. Thanks for sharing it!