How do I reset my Nucleus admin password using MySQL?

"I forgot my Nucleus admin password but I have access to the MySQL database Nucleus uses. Is there a way for me to reset or recover my password through phpMyAdmin?"

The Nucleus SQL Table Reference shows us Nucleus member passwords are stored inside the nucleus_member table. You can run this query on your database to reset your password:

UPDATE nucleus_member SET mpassword=md5('newPass') WHERE mname='yourlogin';

where newPass is a new password that you can remember and yourlogin is your Nucleus login name.

Original forum thread (thanks, ftruscot!):

section: Troubleshooting | submitted by Leng on 2006.Oct.15 | 8862 views

item rate
Total votes: 10 - Rating: 5.00

Please tell us how useful this answer was to you (0 = useless, 10 = very very helpful):