On Mon, 11 Jun 2001, h3rb wrote:
> Ok. I have read the manual =) But one thing I am not clear on. Is if I can
> create a user who can create their own database's..modify them..and drop them
> if need be. But they wouldn't have access to any database on the server. I
> am asking because I host 4 different sites and 3 of them want mysql access.
> And I would not want to have to go and create a new database for these guys
> anytime they wanted. Or are there other ways around this? Thanks,
>
> h3rb
I suggest you take an approach similar to sourceforge:
- set up one or more mysql servers
- on these servers set up a MySQL user for each Unix user
- give user USER access to a database USER only
All of this is done by executing the GRANT SQL command
as a privileged user.
Neil
---------------------------------------------------------------------
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