Hi Jeff,
I think we are both kind of correct. If you are interested
in connecting remotely then you need to set up a different
port and socket, if you only wish to connect to your
localhost then I think you can start the daemon with a
--skip-networking option and specify a new location for
your socket file (--socket=/...). Then when you start
your mysql session set your environment path MYSQL_UNIX_PORT.
At least that's my best guess...
Sonia
On Mon, 30 Jul
2001 [EMAIL PROTECTED] wrote:
> Date: Mon, 30 Jul 2001 14:55:37 -0700
> From: [EMAIL PROTECTED]
> To: Sonia Van Tassel <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Two databases / One Server
>
> Ok clear this up a little for me,
>
> Gerald says:
>
> If you are connecting to localhost, it is using the socket, not
> the port.
>
>
> According to Sonia's reference I need to specify both a different socket
> and a different port, but according to Gerald I must specify one or the
> other.
>
> so which one is it.
>
> Jeff
>
> ----- Original Message -----
> From: "Sonia Van Tassel" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, July 30, 2001 2:37 PM
> Subject: Re: Two databases / One Server
>
>
> >
> > Hi,
> >
> > Look at this (Installing Second MySQL Server on Shared Host):
> >
> > http://www.bitmechanic.com/mail-archives/mysql/current/1550.html
> >
> > Sonia
> >
> > On Mon, 30
> > Jul 2001 [EMAIL PROTECTED] wrote:
> >
> > > Date: Mon, 30 Jul 2001 13:07:09 -0700
> > > From: [EMAIL PROTECTED]
> > > To: [EMAIL PROTECTED]
> > > Subject: Two databases / One Server
> > >
> > > Hello,
> > >
> > > Trying to install two mysql database servers on one Redhat linux
> machine.
> > > The first mysql server is on port 3306 and I am trying to run the second
> > > mysql server on port 3307 but whenever I try to access the second mysql
> > > server via port 3307, I still end up accessing the first mysql database
> > > which is on port 3306.
> > >
> > > Any help?
> > >
> > > Thanks,
> > > Jeff
> > >
> > >
> > > ---------------------------------------------------------------------
> > > 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
> > >
> >
> > --
> > -------------------------------------------------------------------
> > --==- Sonia Van Tassel Software Engineer InterWorking Labs
> > ==--= 4113 Scotts Valley Drive, Suite 200 Scotts Valley, CA 95066
> > --==- [EMAIL PROTECTED] +1 831 430 3610 x23 +1 831 430 9144 Fax
> > -------------------------------------------------------------------
> >
> >
> >
>
>
> ---------------------------------------------------------------------
> 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
>
--
-------------------------------------------------------------------
--==- Sonia Van Tassel Software Engineer InterWorking Labs
==--= 4113 Scotts Valley Drive, Suite 200 Scotts Valley, CA 95066
--==- [EMAIL PROTECTED] +1 831 430 3610 x23 +1 831 430 9144 Fax
-------------------------------------------------------------------
---------------------------------------------------------------------
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