Lost Admin Password in Mambo or Joomla

To reset your Administrator password in Mambo.
Look at your configuration.php file. You will need the following variables:
$mosConfig_user = 'username; // MySQL username $mosConfig_password = 'password'; // MySQL password $mosConfig_db = 'databasename'; // MySQL database name $mosConfig_dbprefix = 'mos_'; // Do not change unless you need to!
At the command prompt , execute mysql like this.....
[root@myserver httpdocs]# mysql -u username -p Enter password: password Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 969185 to server version: 3.23.58-log Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> use databasename
Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Database changed mysql> update mos_users -> set password = md5('newpassword') -> where username = 'admin'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> quit Bye
Or you can use this online tool...
Recover Joomla/Mambo Password

---

other Linux Related Tips...

• BackupPC Customizations
  
• Bru Backup Switches
  
• Setup cfg2html - System Reporting Tool
  
• Disable TLS Connections in Sendmail
  
• Grub + Raid Howto
  
• Named - Turn off Lame Server Logging
  
• Recover Lost Mysql Password
  
• Mounting RAID partitions in a Rescue Environment
  
• Nagios Plugin - Check_dhcp
  
• Nagios check_proc Plugin Fails
  
• OpenOffice opens documents read only from Samba Share
  
• PPTP Proxy Server
  
• Make ProFTPD listen to only internal addresses
  
• RedHat PPPOE script deletes default route
  
• Create a script to rename a bunch of files
  
• RHEL3 - Bash Broken (prior to Taroon Update 5)
  
• Snapgear/CyberGuard pptp forwarding rules
  
• SNMP Commands
  
• Socks Server
  
• Squid - Special Access Settings
  
• X Server wont start