How can I reset my Mambo administrator password?

By | December 9, 2010

Mambo is one of the very popular and powerful Content Management System (CMS) available in the market. Websites cab be created easily with the web based interface and the user friendly features of Mambo CMS.


Mambo administrator password can be changed or reset using its MySQL Database available in your control panel provided by your web hosting services provider.

The most easy way to manage the database is through the phpMyAdmin tool. You need to go to your cPanel provided with you cPanel Hosting account and click on phpMyAdmin in the Databases box.

In phpMyAdmin you need to select Mambo’s database from the drop down menu at the left side. The page will automatically refresh and the table of database’s will be displayed. Access the SQL tab, it can be found at the top navigation bar.

Write the below mentioned SQL Query in the text field available :

UPDATE `mos_users` SET `password` = MD5( ‘new_password’ ) WHERE `mos_users`.`username` = “admin_username” LIMIT 1 ;

“new_password” – replace with the new password to be used.
“admin_username” – replace with the username the password for which should be updated.

Once done, click on the GO button to submit your query. If the query completes without any errors, you would be able to login to Mambo with the newly assigned password.