HOWTO:Share a User DB Between Multiple Sites
e107 Wiki: English | Русский | Deutsch | Français | Magyar | Português | Български | Česky | Nederlands | Ελληνικά | Italiano | Norske | Polska | Slovenščina | Español | Svenska | Translate: Wiki | Page
This guide takes you step-by-step through sharing a user database between multiple sites.
This probably isn't the best solution. There is one small bug: when a user changes their password, sometimes the site that is edited is mean and wont let the user do anything along the way of posting or changing settings. Also, I don't know much about PHP or MySQL. This idea only came to me just before I fell asleep one night and took me half an hour to get working. I have barely tested it.
Several other things:
Essentially E107 is currently not designed to support this - so while enough will happen to convince you its working, and possibly even enough to be acceptable, it won't work 100%. (And this applies to various other suggested methods of achieving the same result, as well).
One other thing: if you want to install a non-core plug-in on the edited install, you'll need to do one of two things:
I: Install it before you edit the e107 install
II: Extract it to your desktop and preform Step 2.
What you'll need:
- A program like  that can find and replace code from the source files of e107 all at once.
- A piece of software like  which installs Apache, MySQL, and PHP.
OK first you'll need to install 2 copies of e107 on your computer to a directory structure similar to this:
MySQL User name:root
Database name:e107 check the create button.
Then just install as usual.
Once you've finished installing the first copy on e107, navigate to the second install and use the following data to install:
Open Dreamweaver and Press Ctrl+F.
You will see a "Find and Replace" dialog pop-up; enter the following info:
the box next to it will require you to navigate to the first install base directory.
then click Replace All.
And that's basically it. You should now be able to register as a new user on one install and show up on the other.