-----Original Message----- From: phpmyadmin-devel-admin@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