Frederic,
Wednesday, January 30, 2002, 4:42:50 AM, you wrote:
FT> I`ll make myself more clear here !
FT> I work for a small ISP, we give a MySQL DB access to each of our corpo
FT> users, if they request it. We just build new more performant machines, and
FT> instead of giving them only a Database, in which they can create as many
FT> tables as they want, we want to give them some sort `root` DB access, in
FT> which they can create as many DB as they want, and so forth.
FT> In a more graphical type of way to explain things, here is the structure
FT> of the mysql data we have ...
FT> in /var/lib/mysql ;
FT> [root@kalx mysql]# l
FT> total 32
FT> drwxr-xr-x 7 mysql mysql 4096 Jan 29 16:59 .
FT> drwxr-xr-x 13 root root 4096 Jan 17 09:13 ..
FT> drwx------ 2 mysql mysql 4096 Jan 29 16:43 mysql
FT> drwx------ 2 mysql mysql 4096 Jan 29 12:55 test
FT> drwx------ 2 mysql mysql 4096 Jan 29 16:59 user1
FT> drwx------ 2 mysql mysql 4096 Jan 29 16:59 user2
FT> drwx------ 2 mysql mysql 4096 Jan 29 16:59 user3
FT> Now, each 'user*' is a DB, which is named after him, that can be accessed
FT> only by this particular user. In a sense, they are 'locked' in their own
FT> DB, and can create as many tables as they what, but they have to
FT> contact us to create yet another DB, for which we have to create another
FT> username + password ... We wish to grant them the priviledge of creating
FT> as much DB as they want.
You can create user by using GRANT, something like this:
GRANT ALL ON *.* TO ''@localhost WITH GRANT OPTION;
or
GRANT ALL ON *.* TO ''@'%' WITH GRANT OPTION;
Get some more info at: http://www.mysql.com/doc/G/R/GRANT.html
FT> There, I think I made myself clear enough =)
FT> Thanks for any help...
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
