The way I am starting my second mysql server is like this :
socket=/tmp/mysqld-new.sock --port=3307 --pid-file=/tmp/rep-mysql
I am not sure how the first mysql server is starting, it is the one that
comes installed with plesk.
Jeff----- Original Message -----
From: "Sonia Van Tassel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 3:32 PM
Subject: Re: Two databases / One Server
>
> 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
