Reset admins password

From XOOPS Web Application System

To reset admin´s password you should change the value of user_password field, in user´s table.

UPDATE user SET user_password = MD5(CONCAT(user_id, '-', MD5('somepass'))) WHERE user_name = 'someuser';