I have two domains that are different sites, but share most of their content. I originally planned to have two databases and use JMS to share the data rather than have to duplicate the content. My hosting provider (BlueHost) tells me that my request to have the rights to grant privileges to MySQL users to show and create views for database sharing can’t be given to me. The reason given is that it is a cPanel issue and they can’t support my request. Anybody else have issues with getting the full privileges?

So for now, without the ability to grant all privileges, what are my options? Basically, I need to have two domains that will share extensions and users. I also need the ability to utilize Joomla newsflash module (or something similar) to display the same “Headline News” on both sites. I also want to share one calendar using the JCal extension. However, I also need to be able to add events that are specific to each site.

I assume that I will
-- need one database, with different table prefixes
-- create a site that will be used to create shared items, such as news articles
-- create a template to replicate the two sites that will define rules for sharing extensions
-- use Article Sharing for JMS to pull shared articles into each site

Please point me in the right direction.

If your hosting provider does not want to grant your MySQL User, I can not do anything except recommend you to change of hosting provider and select one that give you the permission.

To share the articles, you can use our "Articles Sharing for JMS" extension that does not require to have the MySQL User privileges to read the articles coming from other slave site.
Today, we have not yet developped the "mutlisties newsflash" module to read articles from other domain. So I don't have any solution to propose you for that.

Concerning the JCal and Event, this require the MySQL User privileges and therefore require taht you change of hosting provider or have a dedicated server that will give you all rhe access.

Will the MySQL privileges be a problem if I use a single database with table prefixes for the two sites? I won't be needing table views, etc.

Under this single database configuration, should JEvents be shareable to slave sites? I have created events in the slave1 site and the event is shown in the JEvent cPanel for the children sites. However, the event does not get published to the actual calender on the sites that are replicated.

Thanks for the quick answer, btw.

Sharing the extension uses the Views.
So when you need to share something (event in the same DB), you need the MySQL privileges that you hosting provider does not want to give you.

Share JEvent require MySQL User privileges.