The most convenient way to manage the database is via the phpMyAdmin tool available in your DirectAdmin control panel.
Once in the phpMyAdmin select the PHP-Nuke database from the drop-down menu at the left. The page will refresh and the database’s tables will be displayed on it. Open the SQL tab (look at the top navigation bar).
In the text field write the following SQL queries:
UPDATE `nuke_users` SET `user_password` = MD5( ‘new_password_here’ ) WHERE `nuke_users`.`username` = “admin_username”;
UPDATE `nuke_authors` SET `user_password` = MD5( ‘new_password_here’ ) WHERE `nuke_authors`.`username` = “admin_username”;
“new_password_here” – replace this with the new password you wish to use.
“admin_username” – replace this with the username for which you would like the password updated.
Once you are ready, click on the GO button to submit the query. If everything goes fine without errors, you should be able to login to PHP-Nuke with the new password.