Well, experts in the subject affirm that you cannot recover the existing password, but you can reset it to a new password. The passwords are stored using a one-way MD5 hash which prevents recovering the password. But you can reset the password by editing the password field in the database. Set the password to a known value and then you may log-in using that new password.
If for some reason you would to reset your Joomla! admin password, or if you need to offer admin access to somebody else, please change it by doing the following:

For more info and explanations, check this post over here: http://forum.joomla.org/viewtopic.php?t=10985).
For many occasions I have had the need to do things in Joomla CMS when designing web pages, but because of my limitation in knowledge, I end up getting frustrated.
Joomla is a great CMS and all the information can be found in their docs. All you have to do is search for it - of course, you have to know what to look for.
Just some weeks ago somebody asked me if was there any way someone could put a module inside an article. The first thing I did was to go to Joomla and looked for it.
Here is my findings:
You will usually want to associate modules with articles in some way. The modules are allocated to module positions and the module positions appear somewhere on the Web page as determined by the template. However, it is sometimes useful to have a module actually embedded within the article.
To insert a module inside an article, use the { loadposition xx } command, as follows:





Note that this only works when the Content - Load Module plugin is enabled.
If this plugin is disabled, the text { loadposition myposition } shows unchanged in the article.