MySQL hostname for my site

[syren33]

If create a MySQL DB on the free hosting site, what is the path for the host? Would it be just mysite.x10hosting.com or would it be like mysite.x10hosting.com/home/public/dbname? Can someone please copy/paste their db site path so I can fill in the blanks for mine? Unsure what to put. Sorry for the lame question but I searched the forums and couldn't find an answer.

 

[wjh2303]

its just 'localhost'
as in

<?php
$con = mysql_connect("localhost","username_public","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
....
?>

 

[syren33]

Ooooo I see, so it really is localhost. I thought it was only localhost if it was being hosting on your PC and not publicly hosted. Thanks.

 

[wjh2303]

im no expert, but afaik, since php is a sever script, the page is being rendered on the local host from the servers pov, or something...

 

[tmans.lan]

When you create the user and password, you also have to 'add' them to access the database.
When you do add them, you have the chance to set the permissions or ACL. There is also the "ALL PRIVILEGES" check box.
I happen to use a PHP-based CMS and the install script didn't work until I modified the permissions. at:

Tman