Hashed Password via PHPMyAdmin Tutorial

A simplified explanation for newbies

This tutorial will help you through giving a Super Administrator (or any other user) a new hashed password via PHP MyAdmin.

In the article I wrote just before this one, after upgrading to Joomla! 1.0.13, many users have experienced not being able to log in anymore. Fix it like so:

1. You still know what your password is, right? OK. Navigate to PHP MyAdmin. If you’re using cPanel, you should see an icon called MySQL Databases. Click on this icon to get to the MySQL Maintenance page. Scroll down to the bottom and click the PHPMyAdmin link. Choose the database you are going to work with, if you only have one for your Joomla site, picking isn’t quite so hard.

2. On the left-hand side, all tables are displayed. You need the jos_users table near the bottom. Click on this link.
users

3. The table with it’s contents is now displayed. Tick the box next to “password” and then click on “Browse” in the menu:
browse passwords

4. Now all users of your site are displayed with their respective information like their email address and their user-type, i.e. Super Administrator etc. Following logic, you now need to select the user to edit. First tick the box next to the Super Administrator and then click on the pencil below the table. Out of obvious reasons, I have blacked out information pertaining to myself for the public.
user edit

5. In the next form that is displayed you can edit all of the user’s information. Open a new tab in your browser or a new instance of your browser and go to Paj’s Home. This site allows you to enter your password as you know it as proper text and delivers you the hashed version of it. Copy and paste this hashed “password” into the correct box as directed below. Again, all pertinent information to myself has been removed for security reasons:
jos_users password input field
Make sure “save” is displayed in the first input box underneath the form and click on “go”.