I`ll make myself more clear here !
I work for a small ISP, we give a MySQL DB access to each of our corpo
users, if they request it. We just build new more performant machines, and
instead of giving them only a Database, in which they can create as many
tables as they want, we want to give them some sort `root` DB access, in
which they can create as many DB as they want, and so forth.
In a more graphical type of way to explain things, here is the structure
of the mysql data we have ...
in /var/lib/mysql ;
[root@kalx mysql]# l
total 32
drwxr-xr-x 7 mysql mysql 4096 Jan 29 16:59 .
drwxr-xr-x 13 root root 4096 Jan 17 09:13 ..
drwx------ 2 mysql mysql 4096 Jan 29 16:43 mysql
drwx------ 2 mysql mysql 4096 Jan 29 12:55 test
drwx------ 2 mysql mysql 4096 Jan 29 16:59 user1
drwx------ 2 mysql mysql 4096 Jan 29 16:59 user2
drwx------ 2 mysql mysql 4096 Jan 29 16:59 user3
Now, each 'user*' is a DB, which is named after him, that can be accessed
only by this particular user. In a sense, they are 'locked' in their own
DB, and can create as many tables as they what, but they have to
contact us to create yet another DB, for which we have to create another
username + password ... We wish to grant them the priviledge of creating
as much DB as they want.
There, I think I made myself clear enough =)
Thanks for any help...
---------------------------------------------------------------------
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
