External MySQL db

buddybuddha · 10-24-2005, 04:22 PM

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

Peter · 10-24-2005, 04:46 PM

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).

sdsinc · 10-24-2005, 06:14 PM

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 · 10-26-2005, 06:18 PM

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 · 10-26-2005, 08:47 PM

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.

10-24-2005, 04:22 PM	THREAD STARTER #1 (permalink)
buddybuddha NamePros Regular Join Date: May 2005 Location: PA Posts: 216	External MySQL db Is there any way to access a mysql database belonging to website A from website B if I know the user/pass/etc? __________________ The Kevin Dolan Design By Dolan Genetic Programming Source EuroToDollar: Forex Basics

10-24-2005, 06:14 PM	#3 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 9,552	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. __________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 02:24 PM
MySQL Tips	shahid_146	Webmaster Tutorials	4	10-18-2005 01:53 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 10:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 09:17 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 02:17 PM

10-24-2005, 04:46 PM	#2 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,069	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).

10-26-2005, 06:18 PM	#4 (permalink)
a1whs.com Account Suspended Join Date: Oct 2005 Location: Mars Posts: 360	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 ?

10-26-2005, 08:47 PM	#5 (permalink)
Troubled1 NamePros Regular Join Date: Oct 2005 Location: Texas Posts: 306	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.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)