How to access one database from many domains

[ned]

I would like to set up more than one copy of OSC, each on a different domain, so that domains can be localised for different areas. I want all versions of the shop to access one database and all admin will be done from the primary domain. Is this possible?

 

I found a mod which allowed for several shops from one database but this seemed to have each shop offer a sub-section of the products in the database. I want all products available on each domain, I just want them to look different. Does anyone have any ideas on this?

[sanjay_katiyar1]

I would like to set up more than one copy of OSC, each on a different domain, so that domains can be localised for different areas. I want all versions of the shop to access one database and all admin will be done from the primary domain. Is this possible?

 

I found a mod which allowed for several shops from one database but this seemed to have each shop offer a sub-section of the products in the database. I want all products available on each domain, I just want them to look different. Does anyone have any ideas on this?

 

I think this can be done.

 

While installing OSC at step 2 (Database Server information) in the database server fill the hostname or IP Address of the MySQL server instead of localhost.

 

But you have to give privileges to the OSC database on the particuler host with the hostname or IP Address.

 

In the mysql prompt the command would be:

mysql> create database OSC;

mysql> grant all on OSC.* to USER@HOSTNAME identified by 'PASSWORD';

mysql> flush privileges;

mysql> exit

 

(Use the HOSTNAME at the step two of the OSC installation

 

Sanjay

[mark27uk3]

To be quite honest I would not do anything from the above post.

 

Your best bet is to install this contrib

 

Multi Stores

 

Mark