LEMP Development Server

[Chan Chung Hang Christopher]

Verde Denim wrote:
> 
> 
> On Wed, Jun 23, 2010 at 12:44 AM, Christopher Chan 
> <christopher.chan at bradbury.edu.hk 
> <mailto:christopher.chan at bradbury.edu.hk>> wrote:
> 
>     On Wednesday, June 23, 2010 11:37 AM, GNUbie wrote:
>      > Hello Christopher,
>      >
>      > On Wed, Jun 23, 2010 at 10:17 AM, Christopher Chan
>      > <christopher.chan at bradbury.edu.hk
>     <mailto:christopher.chan at bradbury.edu.hk>>  wrote:
>      >> On Wednesday, June 23, 2010 08:56 AM, GNUbie wrote:
>      >>> Hello all,
>      >>>
>      >>> I am seeking an advice on the best way to setup a LEMP development
>      >>> server. The web service is OK already since all the users will have
>      >>> its own UserDir directive. My only remaining problem is on how
>     I can
>      >>> give an administrative privileges on the MySQL server to all
>     the users
>      >>> that will not affect other users.
>      >>
>      >> Why would your users need 'administrative privileges'? Do they
>     need to
>      >> be able to add mysql users? If not, just give them full
>     permissions to
>      >> their own databases.
>      >
>      > I want to give the users their own "UserDir" or "virtual hosted" kind
>      > of MySQL (if that's possible) so that if they wanted to create a
>      > database, add users, etc, they can do it on their own.
> 
>     Run multiple instances then...
> 
> 
> Or, you could set up virtual machines with mysql for each user as well. 
> at least there's some separation there in the chance that one of them 
> does something _unexpected_ .

Multiple instances are separated...what do you think instance means?

Each instance would have its own database 
directory..../var/lib/mysql/user1 /var/lib/mysql/user2

No need to create whole VM's just for another mysql instance