Reset Mambo Admin Password

Filed under: LAMP

Some of my friends ask me several times about how to reset admin password of Mambo CMS. They forgot the admin password, and want to reset it :) . The trick is very simple, but it needs proper access to PHPMyAdmin of the Mambo database. Fire up PHPMyAdmin and navigate to mos_users table.

The next step is deleting the user with SuperUser role in mos_users table. Then you need to insert new Admin user with SuperUser permission. But it can not do to the table directly, because Mambo stores the password in encrypted field :D .

Don’t worry, open the mambo.sql file that contains Mambo database script. Search for the script that doing INSERT the Admin account, copy this line of INSERT statement and run it to your Mambo database. It inserts new Admin user name with default password: Admin. :)

If you’re to lazy for opening and observe mambo.sql file, just run this script in your PHPMyAdmin:

INSERT INTO `mos_users` VALUES (62, 'Administrator', 'admin', 'admin@wherever', '21232f297a57a5a743894a0e4a801fc3', 'superadministrator', 0, 1, 25, '2004-06-06 00:00:00', '0000-00-00 00:00:00', '', '');


April 13th, 2006

5 Comments Add your own

  • 1. abe  |  April 15th, 2006 at 8:01 am

    nice tips..
    how bout if we do not know the password of PHPMyAdmin bang?
    hmm.. simple.. re-install ;)

  • 2. MCA  |  April 16th, 2006 at 10:18 am

    heheh, if you forgot phpmyadmin password, just fire up mysql command prompt and reset root mysql password to blank :D

  • 3. Pauline  |  April 18th, 2006 at 2:01 pm

    Hey! Thanks for the tip!

    An even easier way to do it if you have phpMyAdmin is to just replace the encrypted password with:
    21232f297a57a5a743894a0e4a801fc3

    Then your new password is admin. You don’t actually have to run the sql command.

  • 4. MCA  |  April 20th, 2006 at 7:54 am

    thanks pauline, it’s also doable.
    but sometimes people do incorrect select to encrypted password.

  • 5. Mario  |  March 28th, 2007 at 12:16 pm

    I have done all of this and I have added a new user but no matter what I do I still get an error pop up message saying invalid username, password or access level. I’ve moved my mambo server to a new host and backed up the database before doing the move.. I did a new install (version 4.5.3) and then uploaded all the files (templetes, images etc) the front end works fine, but the admin section cant be access. I’ve tried both approaches with the sql string and just changing the password (Yes MD5) and nothing. If I can’t access the admin I will have no choice but to reinstall but a lot of work will be lost. Any ideas????

Leave a Comment

Required

Required, hidden

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed

Most Recent Posts