From: Basil Murphy
Date: March 29 1999 12:34am
Subject: Adding user accounts & databases
List-Archive: http://lists.mysql.com/mysql/1108
Message-Id: <36FECA7F.4C6004C7@golden.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi everyone,

I just cannot figure out how to do a seemingly simple task.  I need to
setup mysql with 81 user accounts (  each account gets one database to
work with ).

I know how to create the databases ( mysqladmin create <db name> )
but how do I add users with permissions only on a given database?

eg:

Name,	Database
Jane Doe,	janes_db
John Doe,	johns_db
etc...

I am _really_ hoping there is a command line to this so I can write a
script to handle it for me ( just give it the list of usernames ).

Any help is greatly appriciated,
Basil