Bulk addition of users and databases

2004-09-07 Thread Rob Keeling
Having googled extensively, I can`t seem to find a way to do the following. I have a mysql table, with around 1200 usernames in it. What I want to do is programmatically add each user, and create a database of the same name that that user has access to. (This is for a school web server, we want

Re: Bulk addition of users and databases

2004-09-07 Thread Yannick Warnier
Le mar 07/09/2004 à 11:24, Rob Keeling a écrit : Having googled extensively, I can`t seem to find a way to do the following. I have a mysql table, with around 1200 usernames in it. What I want to do is programmatically add each user, and create a database of the same name that that user

Re: Bulk addition of users and databases

2004-09-07 Thread Thomas Spahni
Rob, use your imagination: this is a case for a quick and dirty shell script. You don't have blanks in your usernames, do you? Try something like this: (no guarantee that it works) #!/bin/sh # fetch users from a table and create databases # creates a new table with preliminary passwords for