Website A using database of Website B ?

TotalDesain · 03-22-2007, 03:39 AM

I had 2 webs in different hosting places.
How to connecting php script in website A to using database in website B?

cef · 03-22-2007, 03:37 PM

It's kinda tedious

and it varies based on the database system involved (Postgres is different from mysql is different from Oracle, etc.) but here's the rough process for mysql:
????: NamePros.com http://www.namepros.com/programming/308004-website-a-using-database-website-b.html

1. The database on website B must be configured to allow external connections. With mysql, for example, you need to COMMENT OUT this line in my.cnf:

#skip-networking

And you then need to set external access permissions in the database using the GRANT command. This can be complicated, based on who you're logging in as, what IPs you want to allow, etc. Here's an example line, that allows user "root" to access the system from any IP:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'

2. Make sure that the port on which the database listens (3306 by default for mysql) is open on any firewall on both websites B and A.

4. You can now connect as normal, but instead of using "localhost" as your host string, you'd use "somesite.com" or even just the IP address if you want.

Note that if you want to use a specific hostname ONLY for the database (like db.somesite.com) you'll need to set up a DNS entry for it on website B.

Peter · 03-23-2007, 06:49 AM

Just a note to add what cef said. If the servers are on different networks you will most likely experience slowness on site A as all data is travelling over the network

**enlytend** · 03-23-2007, 08:10 AM

Quote:

Here's an example line, that allows user "root" to access the system from any IP:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'

In the case you mentioned, I strongly advise using the IP of the host you're connecting from, instead of the wildcard (%). And only grant the remote system the privileges it needs.

cef · 03-23-2007, 12:18 PM

enlytend, agreed. If you can restrict access at the grant level to specific IPs/hosts/CIDR blocks, all the better. Sometimes I have to access dbs using remote tools from unknown locations, so for those circumstances I use very loose GRANT permissions.

However, to mitigate this, we then monitor logins via a BFD-like system so that we can dynamically block hack attempts at the firewall, and we also don't allow root logins with full privileges.
????: NamePros.com http://www.namepros.com/showthread.php?t=308004

So I guess that was a pretty bad sample line after all

Thanks for pointing this out.

(But I did say this stuff was tricky

)

03-22-2007, 03:39 AM	THREAD STARTER #1 (permalink)
TotalDesain NamePros Member Join Date: Jul 2004 Location: just go to left side from my right neighbour... Posts: 32	Website A using database of Website B ? I had 2 webs in different hosting places. How to connecting php script in website A to using database in website B? __________________ Free PAD Maker \| Bot Maker Tool

03-22-2007, 03:37 PM	#2 (permalink)
cef NamePros Regular Join Date: May 2004 Location: NYC Posts: 236	It's kinda tedious and it varies based on the database system involved (Postgres is different from mysql is different from Oracle, etc.) but here's the rough process for mysql: ????: NamePros.com http://www.namepros.com/programming/308004-website-a-using-database-website-b.html 1. The database on website B must be configured to allow external connections. With mysql, for example, you need to COMMENT OUT this line in my.cnf: #skip-networking And you then need to set external access permissions in the database using the GRANT command. This can be complicated, based on who you're logging in as, what IPs you want to allow, etc. Here's an example line, that allows user "root" to access the system from any IP: GRANT ALL PRIVILEGES ON . TO 'root'@'%' 2. Make sure that the port on which the database listens (3306 by default for mysql) is open on any firewall on both websites B and A. 4. You can now connect as normal, but instead of using "localhost" as your host string, you'd use "somesite.com" or even just the IP address if you want. Note that if you want to use a specific hostname ONLY for the database (like db.somesite.com) you'll need to set up a DNS entry for it on website B.

03-23-2007, 06:49 AM	#3 (permalink)
Peter NamePros Expert Join Date: Nov 2003 Location: Scotland Posts: 5,074	Just a note to add what cef said. If the servers are on different networks you will most likely experience slowness on site A as all data is travelling over the network

03-23-2007, 12:18 PM	#5 (permalink)
cef NamePros Regular Join Date: May 2004 Location: NYC Posts: 236	enlytend, agreed. If you can restrict access at the grant level to specific IPs/hosts/CIDR blocks, all the better. Sometimes I have to access dbs using remote tools from unknown locations, so for those circumstances I use very loose GRANT permissions. However, to mitigate this, we then monitor logins via a BFD-like system so that we can dynamically block hack attempts at the firewall, and we also don't allow root logins with full privileges. ????: NamePros.com http://www.namepros.com/showthread.php?t=308004 So I guess that was a pretty bad sample line after all Thanks for pointing this out. (But I did say this stuff was tricky )

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