Re: Running mysql on a certain IP

2002-04-08 Thread John Klein
[EMAIL PROTECTED] wrote: > > 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

RE: Running mysql on a certain IP

2002-04-08 Thread Johnny Withers
ECTED] 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 Withe

Re: Running mysql on a certain IP

2002-04-08 Thread Jeremy Zawodny
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

Running mysql on a certain IP

2002-04-08 Thread Johnny Withers
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 addre