While searching to reset the Mambo admin. I came across the “mos_users” table. This table stores the admin password for mambo. Due to the MD5 cryptography the old password is not recoverable.
To reset the password you will need phpMyAdmin to update the existing hashed value stored in the password column with a new value in the MySQL table.
Example:
update mos_users set password = md5(‘yourpass‘) where username = ‘admin’;
In the above example the “yourpass” will be your new password which is a MD5 hashed value.
To create a MD5 value you can get the help of http://pajhome.org.uk/crypt/md5. This site provide us with a good tool to convert our new password into an hash value.
Update the mos_users table with the generated hash value. Now you will be able to login as the mambo admin.
Kishur's Weblog 