How To Reset Wordpress Admin Password Via phpMyAdmin
- March 29, 2009 | 9 Comments
- Share
Sometimes you forget important passwords or you mix them up, you do not know what password was for email address and what password works for other accounts. There are so many private areas on web that you need to memorize many passwords to access them and you can not always go with one password as that is not secure approach and involves great risk.
If you forget you Wordpress blog Admin password, you can always use your email address to retrieve it. Now what if you do not have access to that email account anymore? Or if you forgot your Wordpress username as well? Well you can always kill yourself in such situation reset your Wordpress Admin Password via phMyAdmin.
This tutorial will work for you if your web host is using phpMyAdmin to manage your database.
Step 1: Login to you web host account and go into phpMyAdmin admin page.
Step 2: Now search for the database that you have configured for the Wordpress account.
If you do not have an idea about this because you installed wordpress through cpanel and automated script or even if you have forgotten database name, download the wp-config.php file from the wordpress server. You sould find your database information there.
Step 3: On the left side of phpMyAdmin screen, you will see a list of tables that are used in wordpress. Scroll down and you will se an entry “wp-users”. If you are not using “wp)_“ prefix, you will have something like “yourprefix_users”.
Step 4: On the right, click on the browse button. This is will display all user information and userpass column is passwords columns. Now these passwords do not look same as you set. Do not worry they are same but they are encrypted with MD5 Hash.
Now open a new tab in your browser and go to MD5 hash and write a password and encrypt that to MD5 hash.
Step 5: Now copy this encrypted form and in phpMyAdmin check the box beside your username and click on the pencil icon to edit the entry and replace the password with newly generated md5hash password that you copied.
Click on Go to save the changes and you new password is set.
Now you can login to admin area of your blog with this new password.
Related Posts
- How To Login To Windows Vista As Administrator
- How To Delete A MySpace Account
- Hide and Lock Folders With Password In Windows
- Unlock A Password Protected Memory Card Of Mobile Phones
- Enable/ Disable Administrator Account In Windows 7
[...] Leave a comment | Trackback Easy AdSenser by UnrealI found this PakBlogger.Com post on How To Reset Wordpress Admin Password Via phpMyAdmin. It was shared by Awais Naseer of The Gadgets — one of the very few people who I found [...]
kool man i was not know that easily you can decrypt md5
[...] found this PakBlogger.Com post on How To Reset Wordpress Admin Password Via phpMyAdmin. It was shared by Awais Naseer of The Gadgets — one of the very few people who I found [...]
Thanks @Abhishek yes MD5 is easily to decrypt but it is really ok since it is in phpMyAdmin that is a private area
I missed just tried that again it will be encrypting the new text and we will be replacing the pass field !!
Yes we will write our desire password, encrypt that and then add that encrypted string instead of “Admin”’s already encrypted password
If you don’t have access to phpMyAdmin use this: http://bit.ly/reset-wp-admin-pass
[...] The username can also be changed via phpmyadmin, but this should only be done by advanced users. PakBlogger will walk you through this process. [...]
[...] The username can also be changed via phpmyadmin, but this should only be done by advanced users. PakBlogger will walk you through this process. [...]