Hi there - I'm runing php files on our isp's cgi server to connect to and get data from our mysql db. All works fine. I'm now trying to build a local editor for the db content that will run on my apache server on my machine. Basically I have no idea what to put in the host, username, password and db vars apart from the standard content which works on the isp server. Hope I've explained this okay. Thanks for any help.
cheers
frank
Noob question - connecting to online db from local server
Moderator: General Moderators
-
sleazyfrank
- Forum Commoner
- Posts: 40
- Joined: Fri Aug 19, 2005 3:59 am
- Location: Horsham, West Sussex
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
typically, you just change the "host" argument to the ip of the server you want to connect to making the username and password the same as if you were on that server... although permissions may not allow remote connection, or remote connection by that user, so you may want to read your DBMS' documentation on access rights (if you have the power to alter them)
It's quite possible you will not be allowed remote connection to the server as most hosts turn that ability off.
It's quite possible you will not be allowed remote connection to the server as most hosts turn that ability off.