you can connect with many scripts.
If you connect using php you must know the following 3 things.
1) your Host url example: mysql.securesever.net
2) Your Username which is Case sensitive
3) Your Password also case sensitive
Heres an example:
Code:
<?php
// Your variables
$Host = "[I]your Host goes here[/I]"
$User= "[I]your user goes here"[/I]
$password = "[I]your password goes here[/I]"
// Connecting using Variables above
mysql_connect($Host, $User, $Password)or
die ("Could not connect");
?>
this just connects you. You'll have to take it from there on. You can decide whether you want to CREATE, DROP, ALTER, SHOW, INSERT, LOAD, SELECT, or UPDATE the table you create.