Similar questions have been asked before, such as this one, but none of the answers I've seen so far really tell me what I'm after.
I have a need to set up a Linux box for internal development and testing purposes which will require multiple user accounts. Each account must be restricted in the amount of space taken up by their MySQL database(s), as the testing will attempt to break things and I wish to confine any damage done.
I'm assuming I will need to set up one instance of MySQL per account, with the database files within that account's file space, and limit this with quotas. Is that correct or is there another way that I've overlooked?