Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Lost password after moving from live to localhost
Hello,
I have just revived an old site I used to have to do some testing and recover old posts. I had the database backup and was able to setup the site on my local machine (OS X with MAMP) without a problem. However, I cannot login to the admin panel of the site because I lost my login credentials (the site was taken down 2+ years ago). I am a bit confused, because the password setup/reset via the table txp_users in MySQL doesn’t work (neither the standard “name” and “pass” combination nor new credentials that I set up).
I would be grateful for any hints how I login to the site again…
yot
Offline
Re: Lost password after moving from live to localhost
Hi yot,
If you have access to phpMyadmin you can use
update txp_users set pass=password(lower('pass')) where name='user';
You have to of course change 'pass'
with your new password and 'user'
with your user name but remember to keep them wrapped in single quotes.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Lost password after moving from live to localhost
Hi Colak,
and thanks! TBH I had tried the solution you gave me before but it didn’t work (I am not sure why). But it prompted me to dig into phpMyAdmin more and discovered, under “Browse” tab of the txp_users table my previous login name and (encoded) password. I was able to edit my password and successfully log in.
Phew.
Thanks again!
yot
Offline