Reset your WordPress Admin Password manually.
Advertisements
It may happen sometime that you may lost the password for admin account for WordPress blog. Retrieving it can be a real pain. If you haven’t updated your email in any direct wordpress installation from your webhost, then retrieving your old password can become almost impossible.
But if you have admin access to phpMyAdmin for your blog, then you can change password for your wordpress blog by executing a simple SQL query.
For this you need to login to your phpMyAdmin panel, which you can easily do through your hots’s cpanel. Now, select the database for WordPress blog you want to change password. First of all create a backup of your database, before executing any SQL query. After that click on the “SQL” button, to open the SQL query window, as shown below.
Then, paste the following code into the textarea in the newly opened window. Don’t forget to modify the password(in red) before executing it.
UPDATE ‘wp_users’ SET ‘user_pass’ = MD5(‘PASSWORD‘) WHERE ‘user_login’ =’admin’ LIMIT 1;
Thats it you have successfully changed the password for your wordpress admin account, now login with your new WordPress password.
If you enjoyed this post, make sure you subscribe to my RSS feed!