how to edquota MySQL users?

MDFH · 04-10-2005, 07:02 PM

I have a server and offer users to have a disk quota, with an extra MySQL account using Debian 3.0 sarge, Mysql 4.1, phpMyAdmin 2.6.1-rc2.
Recently I found that MySQL accounts' disk use are unlimited.
Then I look through the whole phpMyAdmin but didn't find anything to limit users'
usage of MySQL (only something such as queries per hour, connections per hour).
How could I merge MySQL data usage into each user's disk quota?

Sincere Thanks!

rick_rick · 05-03-2005, 01:23 PM

All I can tell you is this link:
http://www-106.ibm.com/developerwork...-lpir24-i.html

You'll find here a lot of information about linux quota, and you can read more from lpir23-i about filesistems that supports qouta. (consider a XFS rather then ext2/3).

Enjoy!