Need good modulations or mods and themes for SMF

Please let us know the important or good mods available for SMF on windows or linux server hosting.
Impressed with techarena theme and mods, can some one or admin tell and guide on the mods used here on this site?

Have you tried out some downloads that are available on the original site of simplemachine, you can check their forums as well. Then there is another called tinyportal.net, SMFHacks.com and many more, just do some huntings and you are good to go on.

Glad to see your reply, can you please list the mods used in this forum and downloadable links.

Hope you can guide on theming also.

Well, I dont know which mods are being used in this forums because this are not my property and I dont own this site. Maybe any moderator or the Admin himself can guide you the same. Apart from them I dont see you engaging yourself into hunting but seeking only, are you a complete newbie or so in this things, or do you own any forums / blogs or something that you want to enhance a bit?

I know programming but new to SMF.
Want to install SMF on a site which is under development. Also guidance to have good theme for a online shopping for furnitures and mobiles site.

As the text says, in English, "There are different settings that is to be used for your MySQL server. If you do not know the values, you should ask your host What They Are."
MySQL server name: localhost

"You should ask your host what are the parameters to use mySQL"

@James: need SMF and not mysql.