Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Formatted HDD and lost username and password
Hi,
I was forced to format my hDD and was unable to back up my user name and password for my textpattern install. I’ve read: http://textpattern.com/faq/124/help-i-forgot-my-password but I need to find out my username first, and then reset the password.
How can I do this?
Thanks in advance
Offline
#2 2007-02-11 16:41:30
- monkeynotes
- Member
- From: UK
- Registered: 2005-04-13
- Posts: 41
Re: Formatted HDD and lost username and password
Look in your database, the usernames will be in there under the txp_users table.
Offline
Re: Formatted HDD and lost username and password
Hi,
I’m in a bit of a predicament. Yet again I’ve forgotten a password to a site. So far I’ve tried: http://textbook.textpattern.net/wiki/index.php?title=Resetting_Admin_Password and also and http://textpattern.com/faq/124/help-i-forgot-my-password as a means to get my password set to something I can remember.
Unfortunately I have been unsuccessful. Trying both methods to recover my password have faile and I am stuck staring at the login screen. I’ve used the query option and tried to enter a new password in the password field in lowercase as suggested, but to no avail.
I would be grateful if someone provide some guidance on how to resolve this problem.
Thanks in advance
Offline
#4 2008-07-01 15:07:30
- net-carver
- Archived Plugin Author
- Registered: 2006-03-08
- Posts: 1,648
Re: Formatted HDD and lost username and password
sekhu
do you have access to the database using phpMyAdmin or something like it?
— Steve
Offline
Re: Formatted HDD and lost username and password
Hi Sekhu. As monkeynotes mentions above your post you should be able to find your username in the database in plain text. Unfortunately the password is MD5 encoded (or base64, I can’t remember which) but with the username you should be able to go through the “mail my password” process.
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline
Re: Formatted HDD and lost username and password
Thanks for the prompt response. Yes I do have access to the db via phpmyadmin. I tried to enter a new password in the db by setting the pass field to PASSWORD then entering the new password all in lowercase. It didn’t work.
I also tried to use: [code]update txp_users set pass=password(lower(‘pass’)) where name=‘user’;[/code] in the query thing, and that hasn’t worked either.
I don’t know what else I can try to resolve this issue.
Cheers
EDIT: Hi Stu, I don’t seem to have access to the “mail the password” option, I expect this is a new feature in TXP? I’m still using an older version so as not to break the plugins I’m using.
Last edited by sekhu (2008-07-01 15:15:03)
Offline
#7 2008-07-01 15:13:44
- net-carver
- Archived Plugin Author
- Registered: 2006-03-08
- Posts: 1,648
Re: Formatted HDD and lost username and password
If you have sql access use this…
update txp_users set pass=password(lower('newpassword')) where name='yourusername';
Change newpassword
and yourusername
as required.
(That’s from the FAQ.)
Last edited by net-carver (2008-07-01 15:14:26)
— Steve
Offline
Re: Formatted HDD and lost username and password
hi net-carver,
As I mentioned I followed the instructions from both the FAQ and the Textbook/Wiki but without success
EDIT: Well for some reason I have two dbs (I think) of the same site. I’m not going to delete either of them as they both seem to keep the same data? In any case I edited the password field for the other db and that seems to have resolved the problem.
Thanks for the help
Last edited by sekhu (2008-07-01 15:33:33)
Offline