By dunklea on

Hi everyone,

I am trying to track down information about setting up a single user database across multiple sites. I have four Drupal sites running on a single VPS server and each has their own URL and database. The main thing I want to accomplish is setting up a single user database across all four sites so that a user only needs one account to add content across all four sites. Also, the sites are already running so ideally I would like to be able to do this without pulling everything down again and starting from scratch.

Can anyone point me in the right direction of some good documentation or a contracting company that can help me accomplish this?

Thanks!

⋅ Categories: Drupal 6.x

Comments

kbalderson’s picture

kbalderson commented

For this to work, all of your sites would have to use the same codebase and database, with a shared users table, rather than a shared database.

The way to do this is to use table prefixes. You can read up on that by looking for information about the settings.php file.

http://drupal.org/getting-started/6/install/multi-site