You can reset your Texpattern passwords via phpMyAdmin by following the steps bellow (thanks Ray!)
Login to phpMyAdmin (https://mysql.server.textdrive.com/).
Note: You'll need to substitute server with the name of the actual server for your account.
- Select your Textpattern database from the drop down menu on the left. A list of tables in that db will appear directly below the drop down menu.
- Click txp_users from the list of tables (it’s probably the last one). You should now see all the information for that table in the main content area.
- In the row of tabs at the top of the screen, click STRUCTURE
- Look for the row that starts with the value pass (third one down)
- In the pass row, click the little pencil
- In the Length/Values box, retype the
128with128, then click SAVE. - Click the BROWSE tab. You should now see a list of users for Textpattern.
- Click the little pencil next to the user whose password you want to reset. In the main content area you should now see five columns labeled Field, Type, Function, Null, and 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 the Value column for pass and type in your password.
- In the drop down menu for the row pass, select
PASSWORD. - Click Go
You’re now ready to log back in to Textpattern!
