External MySQL db

buddybuddha · 10-24-2005, 03: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, 03: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, 05: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, 05: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, 07: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, 03:22 PM	#1 (permalink)
buddybuddha NamePros Regular Join Date: May 2005 Location: PA Posts: 212 74.00 NP$ (Donate)	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, 05:14 PM	#3 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 6,285 1,095.94 NP$ (Donate)	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. __________________ Buy now - MassDeveloper.com $500

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 01:24 PM
MySQL Tips	shahid_146	Webmaster Tutorials	4	10-18-2005 12:53 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
HOW TO: Use shell to control MySQL.	abdulmueid	Webmaster Tutorials	16	08-27-2005 08:17 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

10-24-2005, 03:46 PM	#2 (permalink)
Peter Senior Member Join Date: Nov 2003 Location: Scotland Posts: 4,900 0.60 NP$ (Donate)	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, 05:18 PM	#4 (permalink)
a1whs.com Account Suspended Join Date: Oct 2005 Location: Mars Posts: 360 99.15 NP$ (Donate)	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, 07:47 PM	#5 (permalink)
Troubled1 NamePros Regular Join Date: Oct 2005 Location: Texas Posts: 306 224.20 NP$ (Donate)	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)