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