Greetings all. Hope someone could give me some pointers on this.
I am working at a small ISP in Montreal. Some of our corpo users. have
access to a MySQL database, that we created for them (usually, this DB is
named after there username). The way we configured our mysql installation,
which seams a pretty standard procedure, they can create as many tables as
they want in there DB, but of course, they can't another DB.
Well, we would like to do just that.
Is there a way to configure mysql so that the user can create as much DB as
he wants, by making sure every DB created by this user can only be accessed
by him, some kind of 'root' access if you follow my logic. Furthermore,
since we are billing our clients for the disk space they are using, will the
structure of this will ressemble to this ;
MAIN_USER - DB1 - table1, table2, ...
- DB2 - table1, table2, ...
Thanks for any help.
---------------------------------------------------
Frederic Trudeau
PHP Coder, Colocation, Development
[EMAIL PROTECTED]
514.529.3000 ext. 246
---------------------------------------------------------------------
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
