Troubleshooting

How do I reset my Nucleus admin password using MySQL?

Scenario:
"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?"

Solution:
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!):
http://forum.nucleuscms.org/viewtopic.php?t=13773

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

item rate
Total votes: 9 - Rating: 4.44

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

10