WordPress.org

Plugin Directory

Shared User Table Roles

Share user roles when sharing the user table between multiple installations.

To set up multiple wordpress installations using the same database:

  1. Install all wordpress installations using the same database, but using a different $table_prefix in wp_config.

    For example two installations with "eng_" and "nld_".

  2. Designate one wordpress installation as "primary". All other installations are secondary

    For example the installation with the prefix "eng_".

  3. Install and activate this plugin on all secondary wordpress installations.

    In this example "nld_".

  4. On all secondary wordpress installations configure CUSTOM_USER_TABLE and CUSTOM_USER_META_TABLE in wp-config to use the tables (users and usermeta) of the primary installation.

    See below for an example

  5. On all secondary wordpress installations, set SHARED_USER_TABLE_ROLES_PREFIX to be equal to the table prefix of the primary installation.

Primary

For example the relevant wp-config settings for the primary installation would look like:

    $table_prefix  = 'eng_';

Secondary

For example the relevant wp-config settings for secondary installations would look like:

    $table_prefix  = 'nld_';
    define('SHARED_USER_TABLE_ROLES_PREFIX', 'eng_');
    define('CUSTOM_USER_TABLE', 'eng_users');
    define('CUSTOM_USER_META_TABLE', 'eng_usermeta');

Requires: 3.5 or higher
Compatible up to: 3.5.2
Last Updated: 2013-5-6
Active Installs: 70+

Ratings

5 out of 5 stars

Support

Got something to say? Need help?

Compatibility

+
=
Not enough data

0 people say it works.
0 people say it's broken.

100,1,1