Title: multiple blogs, single user table
Last modified: August 18, 2016

---

# multiple blogs, single user table

 *  Anonymous
 * [21 years, 11 months ago](https://wordpress.org/support/topic/multiple-blogs-single-user-table/)
 * is it possible to make different blogs access a single user table? if so, anyone
   wanna share?

Viewing 6 replies - 1 through 6 (of 6 total)

 *  [NuclearMoose](https://wordpress.org/support/users/nuclearmoose/)
 * (@nuclearmoose)
 * [21 years, 11 months ago](https://wordpress.org/support/topic/multiple-blogs-single-user-table/#post-57820)
 * Install WordPress into as many folders as you want blogs. Then, when creating
   the wp-config.php file, you would use all of the same database name, user name,
   and password for all. To make each blog unique in the database, you would change,
   in the wp-config.php file, the table prefix for each blog.
    By default, the table
   prefix is wp_, so you could have blog1_, blog2_, blog_3, etc. So, three blogs
   =three installs=three wp-config.php that have the same login and database, but
   each has its own unique prefix. HTH.
 *  [ryoken](https://wordpress.org/support/users/ryoken/)
 * (@ryoken)
 * [21 years, 11 months ago](https://wordpress.org/support/topic/multiple-blogs-single-user-table/#post-58345)
 * hmm. the replies to this were lost.
    allusion, can you explain how you did this?
   i’m assuming you changed the line $tableusers = $table_prefix . ‘users’; to $
   tableusers = ‘wp_users’ or something like that?
 *  Moderator [Matt Mullenweg](https://wordpress.org/support/users/matt/)
 * (@matt)
 * [21 years, 11 months ago](https://wordpress.org/support/topic/multiple-blogs-single-user-table/#post-58378)
 * ryoken, I just manually modified the $tablesettings in different installations.
 *  [ryoken](https://wordpress.org/support/users/ryoken/)
 * (@ryoken)
 * [21 years, 11 months ago](https://wordpress.org/support/topic/multiple-blogs-single-user-table/#post-58380)
 * what files do i have to change?
    <– newb
 *  [ryoken](https://wordpress.org/support/users/ryoken/)
 * (@ryoken)
 * [21 years, 11 months ago](https://wordpress.org/support/topic/multiple-blogs-single-user-table/#post-58400)
 * bump?
 *  [wnp](https://wordpress.org/support/users/wnp/)
 * (@wnp)
 * [21 years, 11 months ago](https://wordpress.org/support/topic/multiple-blogs-single-user-table/#post-58431)
 * I use just the same setup, since I run an English and a German blog, and didn’t
   want to maintain two sets of users.
    The table names are set in _wp-settings.
   php_, by concatenating the table prefix from _wp-config.php_ and the table-specific
   names. In my case, I first configured my English blog, with a table prefix of“
   wp_wnp_en_”, and created a number of users. Then I configured my German blog 
   with a table prefix of wp_wnp_de, and **AFTER RUNNING INSTALL**, I made the following
   changes: 1. In the _wp-config.php_ file for the German blog I added this line
   under the line setting the table prefix: ` $tableusers = "wp_wnp_en_users" ;  
   2. In the _wp-settings.php_ file, I wrapped the line  $tableusers = $table_prefix.'
   users';  in an _if_-statement which only sets it here if it hasn’t been set yet:
   if ( $tableusers == "" ) { $tableusers = $table_prefix . 'users'; }  Two important
   observations: — when setting up a new blog, **DO THIS AFTER** running _php-admin/
   install.php_. Otherwise _install.php_ will bomb on the attempt to create the 
   already existing table. — be aware that everyone in this usertable will have 
   the same rights on all blogs thus modified, so this is really only good for multiple
   blogs run by the same person (as in my multilingual scenario).

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘multiple blogs, single user table’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 6 replies
 * 5 participants
 * Last reply from: [wnp](https://wordpress.org/support/users/wnp/)
 * Last activity: [21 years, 11 months ago](https://wordpress.org/support/topic/multiple-blogs-single-user-table/#post-58431)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics