You can find all the mysql details of an application in its configuration files. The same is valid for all applications installed through Fantastico too.

For example Joomla stores its mysql details in the file configuration.php in its root installation directory. Please check the documentation for your application for more information.