Tel: 0113 2170419
www.littlefishwebdesign.com
Help I lost my password!
Friday, October 13, 2006
If you've ever had that sinking feeling when you've realised you've forgotten your login, don't worry, help could be at hand. If your password is MD5 encrypted and is stored in a MySQL database to which you have acccess, this post will help.
If you are unsure about the MD5 encryption, follow the instructions below through to step 10 - if the password consists of 32 letters and numbers, then carry on, if not, find another plan! If you are very lucky (and the program isn't as secure as it should be), the passwords won't be encrypted at all and you can see what your password is.
Here are instructions for doing this in cPanel using phpMyAdmin:
- Login to cPanel and click on the MySQL icon.
- Scroll to the bottom of this page and click on 'phpMyAdmin'.
- Select the correct database from the dropdown box on the left hand side.
- In the left hand side list that appears, click on the name of the table that holds your password. NB - unsure of which table? First look for tables called 'user' or 'admin', then start browsing through each table (see step 5) until you find the correct location.
- Click on the tab at the top of page that says 'browse'
- Further down the page that appears there is a small table that shows users and their corresponding passwords.
- Click on the checkbox next to the correct user
- Click on the pencil icon.
- On the page that appears, you'll see a table that you can edit.
- Highlight and copy the 32-digit sequence from the password box and paste it into a new text document. SAVE THIS as a backup.
- Back in the password box, delete the existing contents and type the following in instead: e5f0f20b92f7022779015774e90ce917
- You are now able to login to your admin panel using the password temppass
- Now change your password to something else and don't forget it!!!
Labels: programming, security
