MySQL user permissions

[nadeemshafi9]

Hello

I am creating user accounts throgh webmin for mysql users, i hav a bunch of CMS DB's in my MySql ROOT account, i dont whant the new users to be able to see these or modify them, i would like the new users to be able to create and mod there own DB's.

What permissions should they hav from the folowing:

[quote]select table data
insert table data
update table data
create tables
drop tables
reload grants
shutdown database
manage processes
file operations
grant privleges
reference operations
manage indexes
alter tables
show databases
superuser
create temp tables
lock tables
execute
slave replication
client replication[/quote]

Thanx very much for any help

[fenway]

Creating DBs in a funny thing, since all the permissions are DB-based.  Unless you mean tables when you say DB.

[nadeemshafi9]

ok so db permissions should be set, but what permissions would u give a stander unix user whith a mysql account i mean obviously il create this in to a group and apply accordingly. what should basic privalges be.

[fenway]

I'm not sure what the relevance of the *nix account is... but in general, insert/select/update and maybe delete are all you need.