Web Hosting Talk







View Full Version : Sharing Database


TieuDieuTu
07-01-2004, 06:51 PM
Hi

I currently have a lyrics database that uses mySQL to power. If I want to share that database with another website that also support mySQL on another server, how do I do it?

Please give me a detail instrucions because I am a newbie to this.

Thanks in advance.

pergesu
07-01-2004, 08:16 PM
Just create a new user with the permissions you want on the database. Then give that info to the new site, and they can connect directly to your database.

lamnk
07-01-2004, 08:24 PM
I only know how to do it in cpanel: you can add allow access hosts to your database in mySQL section. On the other site, config your script to access to the IP address of your current server with the user and pass you have created. Simple.