Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2010
    Posts
    2

    Unanswered: Adding user to multiple databases

    Hi There,
    I have just used a tool and instructions to create multiple databases for my Wordpress multisite. It was easy to do with the exception of one thing, adding a user for each database. I want the same user for each data base but don't want to have to go through and add the user to each individual database (256). Is there a way I can add one user to all the data bases.
    My host is JustHost
    I created the databases using MyPHP from my Cpanel.
    To add a user to each db manually I go into MySql

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you have 256 identical databases? whoa!

    you must've created them one by one, yes?

    well, you'll have to add your user one by one, too
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    According to release notes of release 5.5.7 (14 October 2010), LDAP authentication will be permitted. MySQL :: MySQL 5.5 Reference Manual :: D.1.2 Changes in MySQL 5.5.7 (14 October 2010)
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  4. #4
    Join Date
    Nov 2010
    Posts
    2
    Quote Originally Posted by r937 View Post
    you have 256 identical databases? whoa!

    you must've created them one by one, yes?

    well, you'll have to add your user one by one, too
    No I didn't create them one by one. I used this info and tool
    Multi-DB - Allows you to scale your standard Multisite install to allow for millions of blogs... also will vastly improve the performance of your site! - WPMU DEV

    The idea is to let you have 16, 256 or 4096 databases so you can have millions of blogs such as edulblogs.

    It doesn't set up the user and password for each db though

    I'm looking at your link it-iss.com, thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •