Basil Murphy wrote:
> 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?
> Name, Database
> Jane Doe, janes_db
> John Doe, johns_db
> 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,
Search after GRANT syntax in the mysql manual.
'Jane Doe Password'
WITH GRANT OPTION
With this syntax you don't even need to reload the priviledges, because this is