I have done this on about 72,000 domains. Set up one master group. Allow databases to be created under the name the user wants. Then configure the grant statement so that it uses their virtual host name.
GRANT ALL on dbasename TO [EMAIL PROTECTED] IDENTIFIED BY 'somepassword'; FLUSH PRIVILEGES; The server will automatically answer on the virtual socket. Regards, ~Kelly W. Black -----Original Message----- From: Matt Neimeyer [mailto:matt@;neimeyer.org] Sent: Friday, November 01, 2002 10:45 AM To: Daniel Kasak; [EMAIL PROTECTED] Subject: Re: Multiple MySQL Instances... >>On Redhat Linux is there an easy way to have an ISP style setup where >>each "user" has their own database directory? > >Why not just create a database per user and run them all under the one >MySQL instance? >Then call the database the name of the user, or some unique name anyway. >You can then limit access to each database based on the user / ip address >(see the documentation). This is what I'll probably do... but I've seen it done (on our ISP's host for example) and I was kinda wondering how it was done... Thanks though! Matt --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
