mySQL connection??

[awais]

Hi!
It is possible in PHP to use mySQL database from another hosting account. Let me explain...
My script in abc.com and I want to use database from xyz.com.
is this possible? and how

[CheapSolutions]

Yes, this is possible. I beleive you would insert the name of the host instead of localhost. It would be a normal connection. Of course you would need a username and password for that database though. :)

[sicarius]

Not only that, but most of the time the username and password you have is restricted so that they can only log in from the local machine.

[Deuce868]

What you have to watch out for is if remote connections are allowed from the other host. There is a port (I can't recall at the moment what port) that has to be open in the firewall and the config file for their mysql install has to allow remote connections.