jake williamson 28 expounded:
> > hello mike, > > i've got a similar set-up on my g4 - only i'm not quite at the hosting point > yet. > > the way i think i would go about it is create a database per domain and use Do you mean a database within a single instance of MySQL, or a separate instance of MySQL, per the manual, section 4.1.4, "Running Multiple Copies"? Am I off base thinking this would be appropriate? (Just a thought.) Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka > phpmyadmin (saves using the command line!) to grant 'user' permissions to > each domain name. this 'user' would be able to do a full range of tasks with > the database. > > i'd then also set-up 'web' permissions so that hosts connecting in can > select, insert, delete and update rows in the tables - that way the php > scripts can talk to the database. > > hope this helps! > > cheers, > > jake > > p.s. phpmyadmin is excellent! i use it all the time - it at: > > http://www.phpwizard.net/projects/phpMyAdmin/ > > on 19/3/02 11:28, Mike Yrabedra at [EMAIL PROTECTED] wrote: > > > > > > > Hello all, > > > > I am new to the list and have a quick question (I'm sure it won't be my > > last). > > > > I am running Mac OSX and I have PHP and MySQL running. > > > > My question is this. I provide web hosting, and I want to offer my clients > > access to MySQL. How do I set up Mysql so that every virtual host has their > > own set of databases (or tables) that only they can access? I don't want > > one client able to access another client's records. > > > > Let's just say we have 3 domains. How would they be setup using mysql? > > domain1, domain2 and domain 3 > > > > Is mysql just one big database and everyone on the server uses it? > > > > Forgive me I am new and just trying to wrap my head around all this. > > > > Thanks to anyone that can give me some direction. > --------------------------------------------------------------------- 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