How to recover WordPress admin password using phpMyAdmin

June 11, 2013 in Blog by


This method is one of the most popular recovery methods!

First you need to have phpMyAdmin installed.

Most hosting providers provide this software and can be found under cPanel.

If you’re running WAMP, then phpMyAdmin is available under “localhost/phpmyadmin”.

  • Once you’re inside phpMyAdmin, click on the database which is used by your WordPress site.
  • You should find a table entry called “wp-users”. That’s the table whose entry we want to edit. Click on it.
  • The admin user is usually at the top with ID = 1. Select that row and click on the yellow pencil or on “Edit”.
  • Look for the row named “user_pass” (usually the 3rd or 4th one).
  • In that row, under the “Function” column, select MD5.
  • Under the “Value” column, enter your new password. In our tutorial, we’re setting it to “mynewpassword”.
  • To save the changes, click on Go.
  • This updates the password of the admin user to “mynewpassword”.
  • You should now be able to login to your WordPress dashboard!


About Milan

The founder of Dessky, Milan has worked in all aspects of advanced web development, from building large commercialized e-commerce and social network systems to troubleshooting small wordpress blogs. His extensive skills cover virtually every area of web development. Milan works hard to implement tomorrow’s trends utilizing the cutting edge systems of today. He specializes in rich internet web application development and deployment, complex HTML5/CSS3 graphical design layouts, full blown framework-driven rich internet applications, and much more. Milan provides elegant solutions to complex problems encountered by businesses that use internet based services. Also he is the Graduated Engineer of both Computer Science and Information Technology.

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 3.00 out of 5)

2 responses to How to recover WordPress admin password using phpMyAdmin

  1. Waqas Jawed says:

    Thank you Sir!

  2. jayashree says:

    i need to recover my password to access my website. how to recover

Leave a Reply

Your email address will not be published. Required fields are marked *