How can I limit space allowance for MySQL database? Is it possible?

Move the databases to the user space and create a symlink in the data directory of the mysql installation.

This is because users quota is activated on the partition mounted on
/home

so any files in the /home directories will count towards the file owners quota.

Would this cause database corruption if someone went over the quota?