You will find a sample my.cnf file in you
<Installation dir>/support-files/my.cnf. You may have
my-large.cnf etc., Rename it to my.cnf and put in your
data directory. i.e. <Installation Dir>/data/my.cnf
This will already have a section for [mysqld] and
should have a attribute for ports and sockets. For
running multiple servers you need to have one my.cnf
for every Mysql installation and this file should be
in your <Installation Dir>/data/my.cnf.
Each installation should have different port and
socket file names specified in their respective my.cnf
files. So when both of them start they start listening
at the specified port.
Hope this helps.
--- Inbal Ovadia <inbal@stripped> wrote: > Hi
> Thanks for you answer.
> How do you write the section [mysqld] in the my.ini
> (or cnf) file?
> How can I make mysql listen to two ports?
> He listen only to 3306 or to 3307, but can i make
> him listen to them boths?
> Thanks, Inbal
> -----Original Message-----
> From: Goutham S Mohan [mailto:smgoutham@stripped]
> Sent: Thursday, May 15, 2003 11:15 AM
> To: Inbal Ovadia; MYSQL help (E-mail)
> Subject: Re: two servers on the same machine
> On unix you also need to specify the unix domain
> socket file name in the my.cnf (or my.ini). This
> will be used for localhost logins. Looks like
> something similar needs to configured. Check it out.
> Fyi, on unix , we need to specify different
> files for different MySQL servers in the [mysqld]
> section of the my.ini file.
> Goutham S
> --- Inbal Ovadia <inbal@stripped> wrote: > Hi
> > I am working on windows 2000 with MySql version
> > 4.0.12
> > I installed two servers, one on disk C (with port
> > 3306) and one on disk D
> > (3307).
> > When I am running MySql like this:
> > MySql --port 3306
> > everything is ok
> > but when I run it like this:
> > MySql --port 3307
> > I get an error:
> > ERROR 2203: Can't connect to MySQL server on
> > 'localhost' (10061)
> > What does it mean?
> > Maybe the my.ini is not ok?
> > How can I write my.ini?
> > Thanks very much
> > Inbal
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> Goutham S Mohan Bangalore. India.
> Yahoo! Plus
> For a better Internet experience
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
Goutham S Mohan Bangalore. India.
It's Samaritans' Week. Help Samaritans help others.
Call 08709 000032 to give or donate online now at