View Full Version : common database sharing?

05-13-2008, 08:09 AM
I am eager to know , can 2 websites share same database?
That means can these 2 websites add/edit/update/delete the same table of that database?
Please share views,examples or resources on this topic.

05-13-2008, 01:59 PM
Simple answer is yes, the database does not care.
Complex answers could occur if you mean 2 different hosts accessing the same database since then you have to configure MySQL to accept connections from remote hosts.

Need more info.

05-13-2008, 03:55 PM
You can also set up users and permissions so that one user can read the database while another can read/insert/delete/drop/alter. I often like to set up permissions that way when I'm still in testing phases of a script - I don't want people exploiting it and dropping my database because I forgot to escape some form values, ya know?