Alright guys, How can i have one sql database for many websites? Will they all be able to read/write to the same database? Any help on setting this up would be great. Cheers.
How depends on whether the sites are all on the same server or not but yes, it's possible. Read and write permissions depend on the user you log in with to access the database.
And of course, a database can have many users with granular permissions. You can run many sites from a single database and it is quite common to do that on shared hosting setups. Just make sure you prefix the table names with a unique descriptor for each site otherwise it can soon become a mess. (I am assuming you are not going to share the tables between sites? You might run into problems if you are.)
Tables are the main drivers of a database. If he cannot share the tables then he cannot share the database across sites. I believe the answer is-- does your web host permit it. Q...
Some hosting plans come with one database. You can run several sites from a single database. Each site operating from a distinct table set of tables. For example, installing WordPress and phpBB in to the same database. This does not share tables between sites, but it does share the database. Or is the OP asking about sharing the same tables for multiple instances of the same software? For example, running phpBB on two or more sites and sharing certain tables like the user table across the sites? Which as I said above will lead you down an avenue with certain inherent issues.
Yes, it is definitely possible. Even if the sites are on a different server than the database. The server handling mysql will have to allow remote connections, however.
Cheers guys, I'll have to give these ideas a go. I plan on using the same table on differnt websites, not just the same database. Cheers.