Posts tagged as:

password

How to change WordPress Password through phpMyAdmin

by Mahesh Kukreja on November 5, 2009

Sometimes, it may happen that your WordPress blog gets hacked and the hacker changes your administrator password. He may also change your e-mail address. In this case, you cannot reset your password directly from “Lost Password”.  But don’t worry, I’ll tell you a way to reset your WordPress password and also your e-mail address directly through phpMyAdmin. Resetting WordPress administrator password is very easy through phpMyAdmin.

Following are the steps to change WordPress password through phpMyAdmin:

Step 1: Login to your phpMyAdmin using your SQL Database username and password

phpmyadmin

This can be done through cPanel of your host.

Step 2: Browse to your blog’s database

phpmyadmin

Step 3: Find wp_users:

(Edit the default WordPress table prefix “wp_” if needed)

phpmyadmin

Once you click on browse in your wp_users database, you will be shown the users on this blog. Scroll down to the ID which says user_login as admin(by default). Once there click on edit button, the edit button will appear as a pencil logo.

phpmyadmin

Step 4: Edit the values:

Once clicked on edit, you will be taken to a page that appears as below. Here the third field user_pass will have MD5 hashed password under the value column. This value is not in plain text. WordPress, by default, hashes the password to MD5 salt for security reasons.

phpmyadmin

If you want your WordPress administrator password to be “password“, change the value of user_pass to 5f4dcc3b5aa765d61d8327deb882cf99 and click the Go button and then log in to WordPress using your new password..

If you want your password to be different, you can use online MD5 hash generators to generate hash of your required text. You can search Google for “online MD5 generator”, etc.

Example: http://www.adamek.biz/md5-generator.php

Also, if you want to change e-mail address, you can edit value of user_email row.

If you want to change WordPress username, check this tutorial!

Other posts by

Incoming search terms:

  • 5f4dcc3b5aa765d61d8327deb882cf99
  • how to change the wordpress password
  • wordpress md5 password generator
  • Mat khau mac dinh wafie
  • how to change wordpress password via phpmyadmin
  • php my admin user_pass
  • user status wp_users creation admin
  • reset wordpress salt through phpmyadmin
  • reset wordpress 3 3 password phpmyadmin
  • pass wordpress in phpmyadmin

Related Posts
Related Websites

{ 14 comments }