The Joyent Community
A place where the Joyent community can gather, help each other out, and stay informed.
You are not logged in.
#1 2005-04-27 00:22:22
Resetting your Textpattern password
I completely missed this post about a very helpful but cute little movie.
Rather than try and remember the steps or watch that mesmerizing and totally riveting movie again I wrote it all down. Hope it helps.
Go to
https://barclay.textdrive.com/phpmyadmin/
or
https://one.textdrive.com/phpmyadmin/
and login.
1) From the drop down menu on the left select your txp_ database. A list of tables in that db will appear directly below the drop down menu. Near the bottom of that list you should see your txp_user table. Click on that table.
2) All the information for that table will now occupy the main content area of your screen.
There are a row of tabs at the top. Click on the STRUCTURE tab.
3) In the main content area look for the row that says pass (3rd from top) and click on the little pencil to the far right.
4) At the top of the main content area you will see "Field" "Type" "Length/Values*" "Collation" etc. Retype the 128 in the Length/Values box with 128 then click on SAVE.
5) Click on the BROWSE tab
6) In the middle of the content area you should a little pencil. Click on it.
7) The main content area will now have a five columns labeled Field, Type, Function, Null, Value. The third row from the top should be called "pass". At the far right is the encrypted value of your current password. Delete the contents of that box and type in your new password. You can also just retype in your old password.
8) In the drop down menu for the row "pass" select PASSWORD.
9) Hit "Go"
You're now ready to log back in to your TxP interface.
Last edited by Ray (2005-04-27 03:54:50)
Never Mind The Bollocks - Here's The Text Pistols
Offline
#4 2005-04-28 18:20:32
Re: Resetting your Textpattern password
thanks for writing that all out, Ray. :)
from textpattern.org :
some sql commands you can also run that will do the same thing:
UPDATE txp_users SET pass = PASSWORD('newpass') WHERE name = 'loginName';
or
UPDATE PFXtxp_users SET pass = password('NEW_PASSWORD') WHERE user_id = 'USER_ID_OF_USER'
where PFX is the prefix you set in your TXP config (make sure you wrap the whole thing in backticks, though not doing so probably won
Last edited by alicson (2005-05-13 02:17:43)
textpattern.org :: ferrydust.com :: 1haiku.com
VC, MG ~ One-->Bolinas, Chilco-->Rose (pending) ~ happy
Offline
#5 2005-04-30 21:45:18
Re: Resetting your Textpattern password
Ray, I screen shot this and added it to the textbook. http://textpattern.net/wiki/index.php?t … ts_Servers
You can see it here. I gave you credit at the bottom of the entry. Thanks for posting this.
Jamie
Last edited by soulship (2005-04-30 21:45:59)
Offline
#6 2005-05-03 01:12:21
Re: Resetting your Textpattern password
BRILLIANT soulship! Above and beyond. Good job 8 )
Never Mind The Bollocks - Here's The Text Pistols
Offline
#7 2005-05-07 08:03:48
Re: Resetting your Textpattern password
One problem.
This link: https://barclay.textdrive.com/phpmyadmin/ do not work (You don't have permission to access /phpmyadmin/ on this server).
But this one does: https://one.textdrive.com/phpmyadmin/.
And - I don't know which username and password to use - and I guess I'm on Barclay.
-Frode
Offline
#8 2005-05-07 17:35:40
Re: Resetting your Textpattern password
Frode: I believe the link you want is https://mysql.barclay.textdrive.com/. The username and password to use is your MySQL one (which may or may not be the same password as your normal unix account). Hope this helps,
-- Andy
— Andy (andrewlkho)
Offline