89 points
Community rank #614
hyree
El PresidenteJust Getting Started
MemberLikes (0)
hello, i'd bought the vps server special for this multi db wordpress project. can anyone in support team know about the script that can assign one user to thousand of database simultaneously using mysql in phpmyadmin. I'm lack of knowledge in mysql but little bit know about php and html. Can someone in support team help giving the mysql that easy to understand for me or list of example script?
example for adding mysql script:-
host= local host
database = data_1, data_2......,data_4092,
database user name = data_user
database user pass= pass123
Responses (1)
Support Chimp (joined March 2010) Likes (0)
Hey hyree.
I'm afraid that is something a little out of the scope of support.
You would need to loop through all the DBs and assign a given user to each table. I think it will need more than a simple SQL statement.
Perhaps the following plugin might be able to assist:
http://wordpress.org/extend/plugins/multisite-user-management/
I've never tested it, but it states:
There are also a couple of threads here which might interest you:
http://wordpress.org/support/topic/automatically-add-a-new-user-to-all-blogs-on-network
http://wordpress.org/support/topic/automatically-add-all-new-users-to-all-sites-on-network-as-subscribers
Take care.
Become a member