We are in the process of setting up a mysql server (running on W2k3) for student use and have to set up a user and db for each student (100's).
Is it possible to script the creation of user accounts (& set db permission) & script the creation of dbs from a file? UserId and DB name will be thier student ID which I can have in a CSV file already.
Tried googling but had no luck.
Any help much appreciated.