Hi.
I have been making a site which uses mysql and hosting it on my harddrive up until recently. Finally i have a domain name and hosting package. My question, perhaps a little simple, is where do i put my mysql tables on the host's server, and when connecting to my database on a page what do i use a as user, host and password? I gather i have to make accounts and delegate different privelages to each.
Currently my login looks like this on each page

PHP Code:

session_start();
$user="root";
$host="localhost";
$password="";
$database="doorstop";

$connection = mysql_connect($host,$user,$password)   or die ("couldn't connect to server");
$db = mysql_select_db("doorstop")                    or die ("coudn't locate the database"); 


I know this is a silly question, I have books on php and mysql but they seems pretty vague to me. Is anybody aware of a walkthrough lesson anywhere on the interweb which would help me out with this?

Thanks for reading.

What control panel are you using?

errrr. i havnt been using any control pnl. the localhost program ive been using is called xampp and just gives me a folde called mysql to keep my tables in. I will look into getting a control panel. ta very much