Hey, You can limit the size of the database by specifying a quota on the directory created by MySQL for that database.
When you create a database, all MySQL does is create a directory under the data directory for that database. You can then set a quota on that directory using whatever tools your OS supplies. This won't limit the number of tables, or the specific size of any one table, but it might be all you need... Dean. > -----Original Message----- > From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]] > Sent: Sunday, 1 September 2002 9:35 am > To: [EMAIL PROTECTED] > Subject: limiting the user > > Hi everyone, > I am running a FreeBSD server with MySQL 3.23 > I want to let my virtual users create/drop tables and limit the size of > each > table, and also the number of tables they can create. > > Can someone please tell me how I can do this? > Is it possible wit applications such as webmin, or phpMyAdmin? > > Thanks so much > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
