First loginto Cpanel and create the MySql DB, and the DB USER, take note of the DBname, DBusername ,and DBpassword.DBname will be something like
DBname: yourusername_Whatyoupick
DB username: yourusername_Whatyoupick
DBpassword Whatyoupick
The MySQL server should be mysql###
not LOCALHOST, look in your CPanel for correct setting, mysql004.000webhost.com for example (Look in your Cpanel for YOUR proper setting) but LOCALHOST will NOT work
also it defaults to something like home/yourusername/public_html/whatever ,
use /whatever instead, other than that SMF will in most cases fix permissions itself.
ie- If you uploaded all the files to say public_html/SMF
then the local install dir would be (in the SMF installer)
/SMF
not home/yourusername/public_html/SMF like it defaults too.
Change those 2 things, and SMF will prolly fix its file permissions ect itself.

I have installed it many times on several hosts, just did a mnual install here, so if you need more help about setting just ask, but those are the things I noted.
LOCALHOST isn't right, use the mysql###.000webhost listed in your Cpanel
your MySql Username and DB name are prefixed with your 000webhostusername_WHATEVERYOURPICK
and the default install path SMF detects is NOT correct, ignore your home/username/public_html and use just the /path
( Say I uploaded the smf to my new site in a directory called hotforums (ie /home/myusername/public_html/hotforums) then /hotforums is the correct path,
not /home/myusername/public_html/hotforums