Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
[wiki] [Assignment] Instructions for recovering Admin Password
The importance of this is pretty obvious.
There’s an old tute in the resources site here, but judging from the comments to that article, and the outdated links that some of those comments point too, this information is less than comfortably reliable as is. Particularly that comment by hakjoon; leaves a person wondering what the story is now that some time has passed.
There is a page in TexBook, Resetting Admin Password, that is ready and waiting for some up-to-date information. Somebody want to provide current steps here? Or directly in TextBook? Please?
Offline
#2 2006-05-25 16:45:15
- NyteOwl
- Member
- From: Nova Scotia, Canada
- Registered: 2005-09-24
- Posts: 539
Re: [wiki] [Assignment] Instructions for recovering Admin Password
How’s this?
Based on TextPattern 4.0.3 r1188
1) Start phpMyAdmin
2) At the opening screen, select the database for your TextPattern install (eg userid_textpattern)
3) From the list of tables select txp_txp_users. This should present a table structure and a selection of tabbed options.
4) Select the Browse tab. This will display a query field and a list of users.
5) Click on the small pencil (edit) icon next to the user ID entry you wish to edit. This will display a table for the record showing the fields and their current values. Note that only the password hash is displayed, not the plain text.
6) In the function column for the “pass” field, select PASSWORD from the drop down box. You may then delete the hash and enter a plaintext password in the corresponding value field. Letters in this field should be all lowercase. Make sure the box at the lower left says “save” and click on the “Go” button. You will be returned to the previous screen which will display the SQL query you just created. The hash displayed opposite the user ID you selected should have changed (unless you used the exact same password).
Alternatively you can click on the “Edit” link for the SQL query field visible in step 5 and enter the following substituting the desired password for newpassword and the appropriate userID # :
<pre>UPDATE `txp_txp_users` SET `pass` = PASSWORD WHERE `user_id` =# LIMIT 1; </pre>
7) Exit phpMyAdmin and login to Textpattern with your username and new password.
Last edited by NyteOwl (2006-05-25 19:14:38)
Obsolescence is just a lack of imagination. / 36-bits Forever! / #include <disclaimer.h>;
Offline
Re: [wiki] [Assignment] Instructions for recovering Admin Password
If it works, I’ll take it. Your TextBook account is on its way ;)
Offline
#4 2006-05-25 19:43:09
- NyteOwl
- Member
- From: Nova Scotia, Canada
- Registered: 2005-09-24
- Posts: 539
Re: [wiki] [Assignment] Instructions for recovering Admin Password
Yup it works – I had to change mine day before yesterday :)
Thanks – steps posted
Obsolescence is just a lack of imagination. / 36-bits Forever! / #include <disclaimer.h>;
Offline
Re: [wiki] [Assignment] Instructions for recovering Admin Password
Thanks.
Offline