Sure this is possible, take a look at the 'grant' command... and for each
local user add their mysql account giving them access to their database
only.. then other users will not be able to read any db but their own.
ryan
----- Original Message -----
From: "Ulv Michel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 4:53 AM
Subject: Setup own DB for each user?
> Hi all,
>
> I am running a webhosting server using SuSE 7.2 /mysql 3.23 /php 4. We are
> hosting a small amount of virtual servers, allowing our customers to user
> php and mysql. My problem is that every user sees every other users
> databases. Is there a way to setup mysql so that every local user has his
> own empty database? Please tell me how this has to be set up.
>
> Thanks
>
> Ulv
>
>
> ---------------------------------------------------------------------
> 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
