how would i connect to a remote mysql database? just substitute the localhost with the sites ip/domain name? (and user/pass as well)
Yes, but the user would have to be allowed to connect from that ip - check mysql user table.
my hosts permisions are - host = any, and i still cannot connect