Reset the password of the mambo addon script
If any of the client requested us to reset the Password of the mambo addon script , then we need to follow the steps to reset the password.
1)Login to the client’s account through shell and find out the database name of the mambo script.
#vi ~username/public_html/mambo/configuration.php
2)You can find the database like username_mambo1
3)mysql username_mambo1;
4)You can see all the tables of the database(username_mambo1) using the following command at mysql prompt.
mysql> show tables;
5)View all the fields in the mos_users table using the following command.
mysql> desc mos_users;
6)You can see all the users of the mambo addonh script using the command.
mysql> select * from mos_users;
7)You can reset the encrypted password using the following command.
mysql> update mos_users set password=md5(’password’) where id=1;
HINT:Most of the cases the admin user_id is either 1 or 2.