sql database on home server but want to access from hosted

[cddvdheaven]

Due to my hosting provider not allowing the sql database i'm running on there server due to cpu usage i wish to run it from my home based webserver
INTEL P4 1.7GHZ
512MB
2X 120GB RAID DRIVES

I HAVE SQL,AND PHP AND ABYSS SERVER RUNNING ALL ALL WORKS FINE.

The one thing i'm stuck on is how to make the php code that is based on my hosted site talk to the database thats being hosted on my own server ????

any help anyone ?????

many thanks

dave h.

cddvdheaven.co.uk

[whackaxe]

you say sql, so im assuming mysql. ms/postgre sql shouldnt be to differnt i think all you need to do is make your scripts point to your server

in php for example, if your ip is 123.007.15.255

your standard mysql connection will look like this

mysql_connect("localhost","myname","mypass");

ya see the part where it says localhost? well localhost just means "this computer" basicly. so to change you would just need to replace like so

mysql_connect("123.007.15.255","myname","mypass");

all the modifications, of course, take place on the code on your hosts server