MySQL Multi-User Environment

I've been playing with MySQL for a while now and learning about how to set it up in a multi-user environment is new to me.

Currently the only way I seem to be able to do it without setting up multiple servers on a linux server, is after the user has been created and set up their databases I go in manually and give them privileges only their databases.

Is there a way to set up MySQL so that a user when setting up their on databases will not add to the 'global' database

Or do I have to run multiple MySQL processes?

Thanx!

 

 

 

 

Top