1. To create a new account for user "duck" to do everything (but grant privileges) on only database "quack".

bash> mysql -u root -p
Enter passwd: ***

> use mysql ;
> select * from user ;
> insert into user values ( 'localhost' , 'duck' , password('lalala') , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' , 'N' ) ;
> select * from user ;  #The user is now added

> select * from db ;
> insert into db values ( 'localhost' , 'quack' , 'duck' , 'Y' , 'Y' , 'Y' , 'Y' , 'Y' , 'Y' , 'N' , 'Y' , 'Y' , 'Y' ) ;
> select * from db ;    #The associated db is now added

> flush privileges ;

Rather than 'quack', you could name your database 'quack\_%' in which case user duck can create databases named
'quack_whatever' where whatever can be anything.


2. To delete a user and associated dabatase ;

> delete from user where User='duck' ;   #this deletes the user but not the database ;
> delete from db where User='duck' ;     #this deletes the associated database ;

> flush privileges ;