Support » Fixing WordPress » 2 ‘blogs’ – 1 database – common users

  • Resolved jnewto


    Hi all. Basically what I am trying to do is have three separate blogs on the same overall site, which users will be have access to upon a single registration.

    First blog: Some users will be allowed to author posts on 1 blog (any user can comment)

    Second blog: Only the admin will be allowed to author on the second (any user can comment)

    I think this means I’ll need to have both blogs utilizing the same database, but I’m not sure if that’s possible.

    Thanks for help.

Viewing 2 replies - 1 through 2 (of 2 total)
  • What you want to do is share the users database table, but use different table prefixes for 2 of the 3 blogs. So I’d recommend using the default table prefixes for one install and custom prefixes for the others.

    To change the tables’ prefix, change the $table_prefix variable found in your wp-config.php file. Underneath that, for the two installs for which you’re changing the prefix, define the custom users table so that it points to the shared users table:

    define('CUSTOM_USER_TABLE', 'wp_users');

    Ah, it’s that simple! Thank you very much.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘2 ‘blogs’ – 1 database – common users’ is closed to new replies.