Date: 03/02/06 (Java Web)    Keywords: mysql, database, sql

Mambo / Joomla passwords cannot be recovered as they are set using a one-way hash function (MD5). However they can be reset to new values. The user information is stored in the MySQL database (obviously) in the mos_users (for MAMBO) or jos_users (for JOOMLA). The prefix (mos or jos) can be configured and may be named [...]

Source: http://blog.taragana.com/index.php/archive/mambo-joomla-password-how-to-reset-recover/