I always grant all on a particular database to the user who's purchased
the service. I reserve the right to add and delete users, but you could
set up a web page for users to add and remove users for their own
database. making it idiot proof and not exploitable by the script kiddies
would be tougher.
Curtis
On Wed, 22 Aug 2001, Dr. Werner Stürenburg wrote:
>
>
> Jason Brunk schrieb am Mittwoch, 22. August 2001, 19:45:58:
>
> > i read somewhere that you can setup virtual mysql servers, so
> > that users can actually have their own sql server to administer
> > with whatever databases they want to create, with out
> > interferring or even seeing other peoples databases. Does
> > anyone know how to do this? could you help me?
>
> I don't know, but nobody answers, so: I know that it has been
> discussed, and IIRC it is in the readme and manual and it isn't
> hard.
>
> You create a socket each and assign one to each server and a port
> ot listen to. But... it costs memory and maybe some more as you
> double things. This isnt't a good idea if you have 200 clients on
> a machine with a server for each.
>
> ISPs don't have a problem with this as each user has access to
> his database only. He knows the names of the other, but these are
> mostly the domain names, and he knows them from ther directory
> tree already. Same principle: you don't have access except to
> your own.
>
>
>
---------------------------------------------------------------------
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
