Need advice on MU same users per db

  • Resolved arunciks

    (@arunciks)


    12 years, 10 months ago

    I have setup multidomain network. I am using 4 separate dbs for them.
    I would like to share users and have single login through all of them.
    By directions adding below lines to wp-configdoesn’t make sense.

    define(‘CUSTOM_USER_TABLE’, $table_prefix.’my_users’);
    define(‘CUSTOM_USER_META_TABLE’, $table_prefix.’my_usermeta’);

    I want to have user table lets say in the main root WP db. How the other installations would know the table in a different db since they already using connection and tables in own separate db?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Andrea Rennick

    (@andrea_r)

    12 years, 10 months ago

    if you have 4 separate database, then no – you did not set up multisite. it has a shared user table already built in.

    You only need one install, then create the network.

    codex.wordpress.org/Create_A_Network

    The only other way to do what you want is to put all those dbs in one. Might as well actually use multisite.

    Thread Starter arunciks

    (@arunciks)

    12 years, 10 months ago

    Andrea,
    Thank You for the fast reply.

    I did follow the instructions from the same link you had provided me.

    My impression after reading and following setup is that I have to have WP files/installation in subdomains/subfolders already active installed before adding to the network. So if its true I would have to have wp-config.php for every sub-installation.
    If I try to setup Network with empty folder it adds site but the Dashboard and so pointing to the subsite folder and can’t be found.

    When I did my install I did followed article but I did setup WP main root installation and then 3 separate WP isntallations… after adding .htaccess and config changes to the root I was able to add subdomains through network sites… Somehow I am unclear on the part if how the WP network site installations suppose to exist or not prior/during network site add. If they do do they suppose to have config setup with existing dbs or can just be bare installation without config.php

    Thanks one again.

    Andrea Rennick

    (@andrea_r)

    12 years, 10 months ago

    My impression after reading and following setup is that I have to have WP files/installation in subdomains/subfolders already active installed before adding to the network. So if its true I would have to have wp-config.php for every sub-installation.

    No, that’s completely backwards. None of the instructions tell you to make multple installs. There’s one codebase, one install of WP. The sites are virtual – they do not exist on the server. You will not see them via ftp.

    Multisite will not and does not (and never did) find other separate installs on your server.

    When you add a site in network admin, it lives in the db.

    Thread Starter arunciks

    (@arunciks)

    12 years, 9 months ago

    Andrea Thanks.. was my imagination I guess….
    To bad my VPS provider went bankrupt..:) and everyones data caput…
    So I did setup everything from scratch on the new VPS and its very simple and works now.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Need advice on MU same users per db’ is closed to new replies.