• Skip to main content
  • Skip to primary sidebar
  • Skip to secondary sidebar
  • Skip to footer

The Web Mechanic fixes what annoys you about your web site or blog.

Reset Your WordPress Admin Password via phpMyAdmin

August 17, 2009 by Ken Dawes Leave a Comment

Have you forgotten your WordPress Admin password? Do you need WordPress password recovery?  Did you lose access to your WordPress because you fell prey to the WP password vulnerability and your WordPress password was hacked? (Problem was corrected with WordPress 2.8.4.) Take heart, the recovery of your WordPress password can happen outside of WordPress by using phpMyAdmin.


CAUTION!

phpMyAdmin allows you to directly edit your WordPress database! You can totally and permanently ruin your WordPress installation and have to start it all over again. While I have attempted to make this tutorial easy-to-follow and and accomplish, I take no responsibility for any problems that may occur from your modification of your WordPress database.  If you are not comfortable with attempting to work on your WP database yourself, find someone technically competent to assist you in restoring your password.


WordPress Password Recovery

When you set up your web hosting, your webhost likely gave you the login and password to your account. Your account is the place where you set up your email addresses and the like. Most web hosting companies use CPanel as an interface. CPanel makes life much easier!

Anyway, you want to log onto your web hosting account and find phpMyAdmin and click it.

Here’s what it looks like in my CPanel…

phpmyadmin1

Click on phpMyAdmin to open the program in your browser. If your phpMyAdmin is the current version (as of this writing), you should see this…

phpmyadmin

Click on your WordPress database.  You should see the following…

usersScroll down to find the row named “wp_users” and click on the “Browse” icon. This will take you to the next screen…

 

users2

Find the row for the “admin” user and click on the pencil icon to edit the admin password…

editpwLocate the “user_pass” row in the field column. In the “Function” column of that row, click on the dropdown list and select “MD5”. Continue to the “Value” column. What you will see there is an encrypted version of the current password. To enable your WordPress password recovery, click on the encrypted version and remove it so that there is nothing in that box. Now, enter the WordPress password that you want to use for the “admin” account. Don’t worry that it isn’t encrypted, that will be taken care of automatically. Lastly, at the bottom of this last screen, be sure to clock on “Go” to save your change of password.

Congratulations! You should now be able to log into your WordPress with your new password!

Concerned about doing your own WordPress password recovery?  Contact the Web Mechanic and he’ll do it for you for less than $30!

Filed Under: WordPress Assistance Tagged With: wordpress admin, wordpress password

Reader Interactions

Leave a Reply

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

Primary Sidebar

Testimonials

The Web Mechanic not only provided prompt and outstanding service, but also improved the original design of our web site by enhancing our navigational constructs. Sherreen Ogletree
At a time when our chef recipe site traffic was doubling by the month, we had the unfortunate experience of malicious hacking defacements. We were unable to find the bad code inserted in the site and were at our wits end. We found Ken the Web Mechanic via Twitter, and hired him to fix the site. He did a wonderful job making our site secure and safe, was affordable, and easily reachable via email and phone. We highly recommend him for fixing and protecting your Wordpress site, and will use him again in the future without hesitation. Thank you so much Ken! Savory Tv
I put out one tweet on Twitter and there you were! I wasn’t quite sure what to expect but your FAR exceeded my expectations. Not only are you fast in responding but you also take the time to explain everything in a very user friendly way. I was never frustrated and you took care of the problem very efficiently. I felt that you are well versed in what I needed for our website to be up and running. you did more than I thought you even would and I so appreciate it! I will definitely be calling on you again! MingCFO and Founder Reiki Fur Babies, LLC
I have been working with Ken for over 10 years and his web support and attention to detail keeps my website organized, material accessible, and ready for all types of web, tablet and mobile device layouts. His skills also make sure my site is protected, ready for my usage spikes, and synced with my ISP to head off any potential issues.

I highly recommend Ken for taking care of your ISP, web material, and website issues.
Dave Beulke
Ken Dawes of The Web Mechanic made complicated changes to my Wordpress site easy by finding the exact plugins, creating the code, and tutoring me on how to modify my page hierarchy in clear terms that even a novice such as myself could understand. He’s a life saver. Alice Shapiro - Poet's Tongue
I used an acquaintance to build my website originally, but was very frustrated with the way the site looked and worked, and received no help at all. I called the Web Mechanic, and two short weeks later, I have a site I can be proud of. My clients appreciate the difference, and Ken’s work has made my site a valuable tool for my business. I highly recommend the Web Mechanic’s services to anyone needing help with a website. Giles Beilby
Ken was a fantastic resource to me in helping convert my website design and content into WordPress in order to allow greater flexibility. He also was very helpful in helping me understand the steps for starting and maintaining a blog as well as other neat things, using widgets that act as plug-ins for WordPress …whenever I have a question, I know he’s there to help me figure it out! Jen Berkley
I had been dreading creating a workable web site for more than a year, and then, thanks to a referral, I found Ken. He took my concept, improved it with my blessing and made it a reality. I love the layout and site design, but I also love the ease of administration. When Ken finished the site, he explained the “inner” workings to me in terms that I could understand, with no web guru jargon, providing simple instructions so that I can maintain my site. I am 100% satisfied and will definitely be on his repeat customer list. I encourage you to talk with Ken if you want a current, attractive website that matches your business model and that is easy to administer. Rebecca Bond
Ken and Casey Dawes successfully migrated our website to WordPress and made it much easier for the less initiated to maintain and made it look exactly the same as the old site. Well done! Rev. Steve Ellis St. John Episcopal Church Rev. Steve Ellis St. John Episcopal Church

Secondary Sidebar

Topics

  • WordPress Assistance
  • WordPress Security
  • WordPress SEO
  • WordPress Tutorial
  • WordPress Wednesday

Do you want to learn how to use WordPress? Do you want to work on your WordPress site or blog and make it do what YOU want it to do and look like YOU want it to?

Digging Into WordPress is the book you'll want! This amazing book has something for everyone! Whether you are just starting out with WordPress or if you are a WordPress pro, you