External MySQL db

[buddybuddha]

Is there any way to access a mysql database belonging to website A from website B if I know the user/pass/etc?

 

[Peter]

if they are on the same server YES if not it depends on how mysql is configured on site a. Site a's database must either have site b in the allowed hosts list or site a's database must allow external connections.

If the database does meet these criteria you simply use the IP number for the host instead of using localhost (unless they are actually on the same machine then you can still use localhost).

 

[Kate]

That's it.
Instead of localhost connect to the server using IP address or fully-qualified host name. The user name you will be using should be set on the remote system to allow connections from any host or at least a particular IP if you have a static address.

 

[a1whs.com]

I think it is very interesting question , and as stated above if it works for u than , people can get cheap hosting from hosters which do not provide too many sql datbases and use other companies sql server or ur home pc to get all the sql u ever need. So did any of the above work for u ?

 

[Troubled1]

Yes it works a1whs. I used to have an online radio station which I fully automated to run from a website. The website I hosted at a regular hosting company while the broadcast server and mysql databases ran on a computer at my house. It works fine as long as you configure it as stated earlier. The safest way is to put your host in the mysql's allowed host list.