I can't work out on installation where to put zen-cart as can't at the moment get my head round MySQL database. i've had a quick read on the subject, but can't work it out

my site is twilightwomen.co.uk can't work out if it needs to be installed in htdocs or cgi-bin, i'm hosting on streamline and has everything I need but a simple thing of where to put cart with regards to MySQL