5 points
Community rank #7957
each1
NewbieJust Getting Started
MemberLikes (0)
I'm trying to set up the initial playground for the MU install, as a newbie I need to confirm some details, please correct me if I'm wrong.
1, It seems that the first step is to creat 16 or 256 databases and grand the privileges to a database user, I use the tool on http://db-tools.wpmudev.org/db_sql.php
And run the generated script as root, add 16 databases to the database, they can be seen if I login to phpmyadmin as root;
and change the file accordingly, like:
add_db_server('a', 'dc1', 1, 1,'174.*.*.*','localhost', 'mu_a', 'wpmu', 'mypassword');
I've done this step.
3, I assume the database user "wpmu" needs the access right to read and write those 16 or 256 databases, but I've no idea how to write this mysql script. And I don't know where to run the script. Please show me a demo, if I'm wrong in the previous 2 steps please tell me the details, thank you.
7430 pointsCommunity rank #7Supreme DeityMember of the MonthLifetime member
Erstwhile founder
(joined May 2007)
Likes (0)
Hiya,
1, It seems that the first step is to creat 16 or 256 databases and grand the privileges to a database user, I use the tool on http://db-tools.wpmudev.org/db_sql.php
And run the generated script as root, add 16 databases to the database, they can be seen if I login to phpmyadmin as root;
That tool will generate the SQL to create the databases. After they're created you just create a user and grant privileges for the databases.
and change the file accordingly, like:
add_db_server('a', 'dc1', 1, 1,'174.*.*.*','localhost', 'mu_a', 'wpmu', 'mypassword');
If your databases are located on your web server then you can just use localhost instead of the IP.
3, I assume the database user "wpmu" needs the access right to read and write those 16 or 256 databases, but I've no idea how to write this mysql script. And I don't know where to run the script. Please show me a demo
We don't have a script for this. You have to grant privileges manually. PHPMyAdmin will work for this if you login with the root account.
5 pointsCommunity rank #7957NewbieJust Getting Started
Member
(joined December 2008)
Likes (0)
Thank you for your reply, Andrew.
You said the privileges has to be set up manually, if someone needs to set up 4096 data servers for a new install in the future, is there any shortcut for us to do this other than manual set up? Because even a manual install for 256 servers takes a long time. Thanks.
Responses (3)
Erstwhile founder (joined May 2007) Likes (0)
Hiya,
That tool will generate the SQL to create the databases. After they're created you just create a user and grant privileges for the databases.
If your databases are located on your web server then you can just use localhost instead of the IP.
We don't have a script for this. You have to grant privileges manually. PHPMyAdmin will work for this if you login with the root account.
Just ignore that one.
Thanks,
Andrew
Member (joined December 2008) Likes (0)
Thank you for your reply, Andrew.
You said the privileges has to be set up manually, if someone needs to set up 4096 data servers for a new install in the future, is there any shortcut for us to do this other than manual set up? Because even a manual install for 256 servers takes a long time. Thanks.
Erstwhile founder (joined May 2007) Likes (0)
Hiya,
Here ya go:
http://dev.mysql.com/doc/refman/5.1/en/grant.html
Search the page for 'wildcard'.
Thanks,
Andrew
Become a member