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