Multiple MySQL
I've just got a dedicated server that i'm slowly configuring for web/email hosting:I've decided to have ONE Mysql install that all users will be given a single database within. I think I can install/configure that fine. Is it possible for each database to be stored in the user's home directory for disk quotering purposes?
Ideally, i'd like some/all users to be given their own Mysql "session" so that they can create/remove/use as many databases as they want. How would I go about configuring this? I've read the Mysql docs that mention multiple Mysql daemons but I didn't quite understand this from this perspective and i'm not sure is that's what I want?