jbWebWare.com

A fellow e107 user got locked out of their site and asked me what was the best way to recover a password in e107. I thought I'd share my response:

There are two ways you can reset your password.

Using your e107 site to reset the password:
Go to the "http://www.yoursite.com/fpw.php" page and follow the instructions.

Manually changing your password in the database. Here are the instructions to do so using "phpMyAdmin":

FIRST THING YOU NEED TO DO IS BACKUP YOUR DATABASE!!!

Then open the "someprefix_user" table (Click "browse" so you can see the table data instead of the table structure). If you installed the site, then you should be user_id 1.

Click the "Edit" icon (looks like a pencil) to the right of your user data.

Notice that the "user_password" data is a long string of random text. It's actually your encrypted password. The encryption method used by e107 is "MD5".

What you want to do is remove the "MD5" encrypted password, then enter your new password exactly the way you want to type it when logging in (it IS case sensitive).

Before you press "Enter" or click the "Go" button to save your new password, you need to click the drop down box to the right of the "user_password" field (under the "Function" column) and select "MD5". This will encrypt the password that you entered when "phpMyAdmin" saves this change to the database.

Now you can click the "Go" button to save the changes to the database.

That's is. Go ahead and log in to your e107 site using your new password.

If you have any questions, or you need to manually change the password in the database but are using software other than "phpMyAdmin" and need a hand with it, let me know.