Chapter 7. MISCELLANEOUS ITEMS

Table of Contents

Forgotten Password
Using billing plugins
Customizing templates
Customizing themes

Forgotten Password

If you forget your password, you have to get your SQL thinking cap on and change it. If you don't recall the name of your database, do:

$ md5sum.textutils --string oldpassword

d5b5fffc89f961903fb3c9a173f1b667  "oldpassword"

$ mysqlshow

Then login as follows:

$ mysql phpaga

mysql> select usr_id, usr_login, usr_passwd from users;
+--------+-----------+----------------------------------+
| usr_id | usr_login | usr_passwd                       |
+--------+-----------+----------------------------------+
|      2 | sean9     | 4f2a1493c661c0f2d2ee9a37040b8082 |
|      3 | neal9     | 3e7023ed317ed603851f22d510924ca1 |
|      4 | akahn     | b27fad92c6ddeddf0bfd6eb9871a8c79 |
+--------+-----------+----------------------------------+
3 rows in set (0.00 sec)

mysql> update users
       set usr_passwd = 'd5b5fffc89f961903fb3c9a173f1b667'
       where usr_id = 4;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Note that if you don't have md5sum.textutils installed you can also use this bit of php code to get the hash string:


<?php print md5("oldpassword")."\n"; ?>