Re: mysql & quota

[Sasha Pachev]

Mark Stier wrote:
> 
> hi
> 
> is it somehow possible to give users with disk quota restrictions access
> to mysql without 'disabling' the quota functionality?
> 
> (eg. by setting a different data directory for each user?)
> 
> Regards,
> 
> Mark
> --
> Space Academy - http://fly.to/space-academy
> personal homepage - http://zap.to/oxen

Create a database for each user, then chown the directory associated
with it to that user, but make sure to set the group permissions in such
a way that mysqld will have read/write access to it. Since Unix and
MySQL have separate user databases, it will be your resposibility to
ensure consistency. 


-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)