Yes, I found this about 2 seconds after I sent my email..
However, I still can not get mysql to run on either
a) different ip address on port 3306
or
b) same ip address on port 3307
Either way, I get the error:
020408 15:47:00 mysqld started
020408 15:47:00 Can't start server: Bind on TCP/IP port: Address
already in use
020408 15:47:00 Do you already have another mysqld server running on
port: 3306 ?
020408 15:47:00 Aborting
020408 15:47:00 /usr/sbin/mysqld-max: Shutdown Complete
020408 15:47:00 mysqld ended
Here's the setup I have:
in my.cnf:
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
.
.
<!-- snip -->
.
.
[mysqld_multi]
mysqld = /usr/bin/safe_mysqld
mysqladmin = /usr/bin/mysqladmin
[mysqld2]
socket = /home/mindbender/production/db/mysql.socket
port = 3307
pid-file = /home/mindbender/production/db/mysql.pid
datadir = /home/mindbender/production/db
#EOF#
Then, I simply want to run
>mysqld_multi start 2
but, it says it can't bind to 3306 on the ip address..
and as you can see I'm telling it to use 3307
I've even tried:
/usr/sbin/mysqld-max \
--bind-address=10.0.0.50 \
--port=3306 \
--data-dir=/home/mindbender/production/db \
--socket=/home/mindbender/production/db/mysql.socket \
--pid-file=/home/mindbender/production/db/mysql.pid
And this does nothing at all except display the variables I may
set when I run mysqld_max (as if I didn't pass anything at all for
mysqld_max to do at startup)
I'm at a loss here?
I read somewhere that mysql reads /etc/my.cnf before it does any
command line options, is this correct? If so, how can I have a my.cnf
file
and then run two servers if I have to have a [mysqld] section in the
my.cnf
file that tells the server which port and socket to listen on?
Should I remove the [mysqld] section from the file and start the servers
from the command line using command line options and just leave the
innodb/mysql-client options in my.cnf ?
Any help ?
---------------------
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-----Original Message-----
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 08, 2002 3:10 PM
To: Johnny Withers
Cc: [EMAIL PROTECTED]
Subject: Re: Running mysql on a certain IP
On Mon, Apr 08, 2002 at 03:04:58PM -0500, Johnny Withers wrote:
>
> I need to run two MySQL servers on one machine.
>
> One needs to use /var/lib/mysql.sock
> and the other needs to use /home/mindbender/production/db/mysql.sock
>
> One needs to run on one ip address:
> ie: 10.0.0.10:3306
> and the other on 10.0.0.11:3306
>
> how do I tell mysql to run only on a certain IP address?
--bind-address, as described in the manual.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 60 days, processed 1,631,748,118 queries (313/sec.
avg)
---------------------------------------------------------------------
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
