I'm starting a project where I need two different websites to interact with one database. They have different domains and different source codes.
My servers providers are Hostgator and Linode. Hostgator is a shared host and Linode is a virtual server where I can install a few versions of Linux including Ubuntu, Centus, etc.
My question is how do I set up a Database on one cPanel and allow other cPanels to connect to that database?
If someone knows a solution for this using Hostgator I would really appreciate as it seems to be a faster and maybe less time consuming task.
I also wonder about Linode, because I secretly believe that it's not doable with Hostgator, but on that case I wonder: 1 - how do I deal with two domains and two source codes? 2 - how do I connect both with the same database?