The short answer is that you can't, if you're using a named pipe
(/tmp/mysql.sock, or some such). That would require every user having their
own installation of MySQL, which may be what you want.
Why not have the users connect via TCP/IP, and just set permissions
correctly? They would be able to list the other databases on the server, but
if permissions are set correctly, they will only be able to have access to
their own databases.
Hope that helps.
j----- k-----
On Thursday 30 August 2001 12:21, Mustafa Hashmi wrote:
> Gerhard,
>
> Thank you for your response.
>
> Emphasizing that I am new to this, could you describe in a bit more detail
> how I could put this in the new root structure? (client's chrooted
> structure)
>
> If this is too extensive to properly explain, is there some documentation
> available which might help?
>
> I appreciate your help.
>
> Regards,
> Mustafa.
>
> ----- Original Message -----
> From: "Gerald Clark" <[EMAIL PROTECTED]>
> To: "Mustafa Hashmi" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Thursday, August 30, 2001 1:03 PM
> Subject: Re: Virtualizing MySQL
>
> > Two problems.
> > The clients don't have access to the databases, the server does.
> >
> > Chrooted clients will not be able to read and write the named pipe
> > unless it is in their new root structure.
> >
> > Mustafa Hashmi wrote:
> > > Hi all,
> > >
> > > I am in the process of creating a Virtual Server - and pretty much all
> > > aspects have been completed to my liking. This includes web / mail /
> > > ftp
>
> and
>
> > > ssh.
> > >
> > > The next hurdle is virtualizing MySQL, and I would like to do this by
> > > sharing the same MySQL server across multiple chrooted clients. This
>
> way,
>
> > > they can have unlimied databases / tables under their userID without
>
> looking
>
> > > at, or disrupting, any of the other clients in their chroot.
> > >
> > > I am also rather new to this, so please feel free to point me to a URL
>
> which
>
> > > may help. I've tried though - couldn't find anything relevant to my
>
> cause.
>
> > > I appreciate your time.
> > >
> > > Cheers,
> > > Mustafa.
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > 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
> >
> > --
> > Gerald L. Clark
> > [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> 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
--
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601
---------------------------------------------------------------------
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
