Textpattern CMS

#1 2005-10-27 18:15:09

mengels

New Member

Registered: 2005-10-27

Posts: 2

Techno-peasant lost in Textpattern

Relying on someone else has not worked and now I cannot recall my username or password! (Actually, the password is probably correct).
I found this:

“If you’re the only user with publisher privileges, you’ll need to use phpMyAdmin or the mysql command line to reset your password. Use the following query:

update txp_users set pass=password(lower(‘pass’)) where name=‘user’;

..where pass is the new password, and user is the login username.”

Now, this is really tough for me… being the “only user, etc.”, I do not know what “phpMyAdmin or the mysql” command lines are! Where the heck do I “use” the “query”, and how?

Please, anyone, can you help me with this conundrum? We have a “website” that has been unattended to for nine months and I HAVE to figure it all out, somehow, sometime.

Thanks for your time.

#2 2005-10-27 18:31:40

NXArmada

Member

From: Sevierville, TN

Registered: 2005-09-13

Posts: 82

Re: Techno-peasant lost in Textpattern

in put the update txp_users set pass=password(lower(‘pass’)) where name=’user’; query into what ever program you used to create the MySQL database used by TXP. Alot of hosting companies dont provide the Query box but only allows creation of Database. That is were phpMyadmin comes in, some hosting companies provide phpMyadmin on there servers just need to find out how to access it..

phpMyadmin is a free program that lets you edit and maintain your MySQL database. easy to use and setup.

Last edited by NXArmada (2005-10-27 18:33:14)

---

Ryan

#3 2005-10-27 23:35:34

zem

Developer Emeritus

From: Melbourne, Australia

Registered: 2004-04-08

Posts: 2,579

Re: Techno-peasant lost in Textpattern

I clarified the FAQ a little:

If you’re the only user with publisher privileges, you’ll need to access the database directly to reset your password. Most web hosting accounts provide direct MySQL access using a program called phpMyAdmin, or via the command line. If you’re not sure how to access either of these, ask your hosting company’s tech support.

---

Alex

#4 2005-10-28 06:02:42

mengels

New Member

Registered: 2005-10-27

Posts: 2

Re: Techno-peasant lost in Textpattern

Thanks Alex. I did contact their support (GoDaddy) and they led me through a few different “exercises” which eventually led to my ability to gain access via an ftp address. THis is not good for me ‘cause I do not know what to do there!

It seem that I must find the password at Textpattern – somehow becuase it must be different than the one established at GoDaddy… so I emailed “dean@testism.com” and I am anxiously awaiting a reply…

Mark

#5 2005-10-28 06:25:18

zem

Developer Emeritus

From: Melbourne, Australia

Registered: 2004-04-08

Posts: 2,579

Re: Techno-peasant lost in Textpattern

I’m not sure what GoDaddy told you, but, umm, that won’t help.

A quick google search suggests GoDaddy does indeed support phpMyAdmin, and that there’s a link to it in the GoDaddy admin panel.

---

Alex