Hi,
I work in a university and need to give students access to a MySQL
database from their php enabled web server.
The apache/php stuff is all working but I was wondering on some advise
as to how best to deal with a large number of students.
Ideally waht I'd like to do is to setup MySQL so that each student has
their own unique database, accessible from their own userid, this
would mean a large (1000) number of relatively small databases (I'm
hoping to restrict each student to approx 20Mb for Db usage) and they
could setup their own tables etc via something like phpMyAdmin. They
can have full access rights to their own individual db - but not see
any other students's.
The machine I've set aside for this purpose is a Sun Ultra 5 - 256Mb
ram - plenty of swap and fast local disk.
ALso I want to restrict the size of the database for each studnet - as
this is only for learning php/mysql purposes and if theirs a more
serious project then I can provide other facilities.
Is this going to to be achievable - how are other Uni's or ISP who
provide MySQL dealing with this tpye of issue.
If I can't restrict the size of each database - should I be pursuing
some other db option?
Many thanks in advance
Rgds
Surinder
------------------------------------------------------------------
Surinder Singh Dio , School of Computing and Mathematical Sciences
[EMAIL PROTECTED] , University of Greenwich, London, England.
---------------------------------------------------------------------
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
