I forgot my password, but I also forgot to change the default email address for id 1 "webmaster@clicdev.com" to my actual email address. So I can't get emailed a password reminder.


I know how to access the table in MySQL, but I don't know the SQL command that will change the email address for me.





Btw, it's for this board

Last edit by Jasper on Dec 10, 2006, 10:30 am

---

doesn't come here often, cause he has no free time ;_;

update [yourprefix]users set password=PASSWORD('[yourpassword]') where user_ID=1;

Of course, you have to replace [yourprefix] and [yourpassword] with their real value.

Afterwards I would recommend changing that password using the user cp as I do not trust passwords generated using PASSWORD() - nBBS is compatible with this format but it's only to support user bases migrated from other software.

---

Thanks Chris, that worked

---

doesn't come here often, cause he has no free time ;_;