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 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
