[Phpmyadmin-devel] batch user & db creation

[Rabus]

-----Original Message-----
From: phpmyadmin-devel-admin at lists.sourceforge.net
>
> On Tue, Jan 07, 2003 at 08:41:00AM -0500, Marc Delisle wrote:
> > - A new batch user and db creation mecanism. Starting
> > from a local file like this:
> > 	user1, password1
> > 	user2, password2
> > 	user3, password3
> > 	...
> >
> > we could upload this file.  There would be a radio button:
> > 	() just create users
> > 	() create users and generate a db named after the user
> > 	() create users and generate a privilege that enables users to
> > 	create their dbs,
> > 	   with the username as a prefix
> extend the format slightly
> user1, host1, pwd1, db1
> user2, host2, pwd2, db2
>
> and the "generate a db named after the user" can instead use
> the specified dbname if given, else it can use the username
> as the dbname.
>
> I think the file should have quotes in it, since space and
> comma characters could be found in usernames/passwords/dbnames.
> so:
> 'user1', 'host1', 'pwd1', 'db1'
> 'user2', 'host2', 'pwd2', 'db2'
>
> maybe swap the order of host and password for easier use.
> data like this can be generated in Excel easily as CSV format
> with quotes.

imho, the order of the values can easily be made configurable for the
user.
All of the fields could be left out, theoretically:

- If the usernames are not specified, phpMyAdmin could generate
usernames using a prefix given by the user (user_0001, user_0002,
user_0003, etc.).
- If the hosts are not specified, a predefined host, e.g. '%' or
'localhost', is used for each user.
- If the passwords are not included in the file, they could either be
left blank or phpMyAdmin could generate random ones.

Regards,

Alexander