Connect to database on another server

Worker Joined: Dec 03, 2005 Posts: 153

Hi all

Is it possible to connect to a database on another server.

For example Phpnuke on a webhost server hosted by a company and my mysql database on a server at home.

Could this be done???

many thanks

John

registered · Posted: Thu May 25, 2006 6:16 am

Off the top of my head, I believe it is possible because I believe mySQL can do this (remote connections), but the questions become:

1) Will your host allow traffic OUT from it on the necessary port
2) Will your ISP allow traffic IN on that port (don't forget your own firewalls)
3) And then somehow nuke's db calls have to be changed to invoke a connection on a remote host.

Sorry, have never done this, nor really looked into it, just giving possibly some direction for your further research.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Yes, it can be done. You have to give the server name a legitimate service name/IP that links to your domain name on your pc at home. Obviously you must be running MySQL as a server at home and have the correct port opened for Internet access.

Posted: Mon May 29, 2006 11:01 am

Hi

Many thanks for your reply, I have asked my webhost and they don't seam keen about.

cheers for the advice

Posted: Tue May 30, 2006 6:31 am

No surprise here... Sad