WordPress.org

Ready to get started?Download WordPress

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
Downloads: 376

Ratings

5 stars
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