i'm using Mysql 3.23 and need to create several users, all of which need the ability to create and delete their own databases, but they should not be able to see other people's databases.

How is this possible? Can it be done with privileges alone?

I know i can create databases for people and then give them permissions on each database individually, but ideally the users need to be able to create and delete their own databases without having the ability to do it to everyone elses.

Thanks in advance, people!