How to reset a WordPress password on the database

Posted on: Monday, 25 May 2015 13:03

You’ve gone and forgotten your password? You didn’t set up your recovery email address? No, it wasn’t your fault, the client has forgotten? You inherited the site and the records aren’t right? Well whatever the reason, don’t panic. This guide will show you how to recover that account without having to do anything too drastic.

This guide isn’t for total noobs. I’m assuming that you can fend for yourself to a certain extent. If not you need to show this guide to your web developer and ask them to help you out. It also assumes that you have access to a copy of phpMyAdmin which is installed on virtually every hosting platform out there.

So first you need to locate your phpMyAdmin install. If you have Plesk on your server, log in to that, drill down to the problem site and then into the database settings for that account. If you have cPanel then you will be able to get to phpMyAdmin through that too. If not then you probably have access to it via your main hosting admin / billing panel. Try searching your hosting companies support section if you can’t find it.

You might have more than one WordPress installed in the account and if you installed it with a script installer then it could have a cryptic name like wp_wordpress5 or something. If you’re not sure about the database name that the site is using then check wp-config.php which is in your root folder. Normally the first line in this will be something like this:

define('DB_NAME', 'somesite_wp');

Thats your database name so make a mental note to look for that when we get into phpMyAdmin.

Ok follow the procedure you discovered earlier to get phpMyAdmin loaded up. Over the years phpMyAdmin has had some facelifts and changed slightly. You might see some slight visual differences in if your host hasn’t kept up to date but push forward and everything should work ok.

The initial screen will likely already have your database selected and you will see a list of tables down the left hand side which looks like this:

image

If not, click the Databases tab along the top. Then in the list of available databases just click on the database name you made a note of earlier.

The account details are all stored in the wp_users table. Click on that either in the left hand side menu or if you have the structure tab open you click also click the name or the browse button in the main page.

This will take you to a page which has the Browse tab selected at the top:

image

Look down the table and find the account you need to reset the password for:

image

If you have a lot of users you might need to use the pagination buttons at the bottom of the page:

image

Or if its a huge site you can search by clicking the “search” tab along the toolbar at the top:

This will take you to a page that searches the current table. You will probably want to search on the user_login line and make sure “LIKE” is selected in the Operator column (this will match partial usernames too):

When you find it you need to click the edit button for that row:

image

Now we’re in business.

The Password Reset Technique

You will see  a row called user_pass. In it there will be a line of gibberish text. To update your password just type your new password into the Value field:

image

But wait! There’s more. The text was originally in gibberish because the password is encoded using an MD5 hashing technique. Open up the empty select box in the screenshot above (the Function column) and select MD5. This will apply the MD5 hash function to your text and you too will be the proud owner of a line of gibberish.

Just save it out to complete this process. At the bottom of the page, make sure Save is selected and click Go:

image

You will now be able to log in to your WordPress site with the username and the new password you just encoded.

ASP.NET 5 Beta 4 “Couldn't determine an appropriate version of KRE to run”

Posted on: Saturday, 23 May 2015 13:57

I’ve started getting to grips with the new ASP.NET 5 project system and during the course of this process I’ve encountered a few glitches. This time a project I downloaded based on earlier beta3 code wouldn’t run for me in the browser. I found the solution to this issue in this article.

ASP.NET 5 Beta 4 "The Debugger cannot continue running the process. Unable to start debugger"

Posted on: Friday, 22 May 2015 13:00

I’ve just started getting to grips with the new ASP.NET 5 project system and its friends. As everything is still in development there are still some kinks being worked out. Here is a quick solution if you see an error saying "The Debugger cannot continue running the process. Unable to start debugger".

ASP.NET 5 Beta 4 “The 'prepack' script failed with status code 99”

Posted on: Thursday, 21 May 2015 12:05

I’ve started getting to grips with the new ASP.NET 5 project system and during the course of this process I came across a compilation error “The 'prepack' script failed with status code 99”. It was a pretty easy fix which I’ve detailed below.

SOLVED: Why my Joomla contact form was refusing to send its email

Posted on: Monday, 13 April 2015 02:10

While working on a Joomla website recently I had the annoying problem of a contact form failing to send. It took longer than I would have like to spend looking for the solution so hopefully you will find this article before spending the time I did trying to get to the bottom of it. As usual, in hindsight its actually quite simple.

SOLVED: Contact Form 7 won’t send your forms

Posted on: Monday, 6 April 2015 02:07

You’ve finished the site, the client has signed off and all that’s left is the launch but the form test keeps failing. Right, we better solve this one quickly then!

Supporting nested shortcodes in WordPress

Posted on: Monday, 30 March 2015 23:59

If you’re writing your own [shortcodes] or have done in the past then its important that you follow this little tip. It will only take a couple of minutes to implement and it will save your end-users from problems.

Bootstrap 3 Show Many Slide One Carousel

Posted on: Sunday, 29 March 2015 13:18

This is a sample showing how to configure the Bootstrap 3 carousel to show many panels at once but only slide one at a time.