As long, only ONE service is running at a time it's ok to use same port.
The database `mysql` are not 100% compatible between 4.0 and 5.0
So you should use seperate datadirs for each service.
my.cnf could contain:
datdir = path/to/v4data
datdir = path/to/v5data
For installing them use:
c:\path-to-4.0\bin\mysqld.exe --install-manual mysql4
c:\path-to-5.0\bin\mysqld.exe --install-manual mysql5
From: Jorge Bastos [mailto:mysql.jorge@stripped]
Sent: 24. oktober 2006 21:16
Subject: Fw: Win32 dev on two versions of mysql
And don't forget to run them in diferent ports also.
----- Original Message -----
From: "Daniel da Veiga" <danieldaveiga@stripped>
To: "MySQL Win32 List" <win32@stripped>
Sent: Tuesday, October 24, 2006 7:05 PM
Subject: Re: Win32 dev on two versions of mysql
> On 10/23/06, Brad <mysql@stripped> wrote:
>> I read the recent thread (Sept) on installing two instances of mysqld
>> and binding them to two different IP addresses, but unfortunately I have
>> to develop on two different versions of MySQL and they both need to work
>> on 127.0.0.1 (localhost)--though not at the same time, of course.
>> What's an easy way to accomplish this, so that I can (quickly, if
>> possible) switch between say, 4.1 and 5.0.23 or whatever and have them
>> both on localhost? I realize that I can remove the instance of the
>> service on each, in turn, using the MySQL Server Instance Config Wizard,
>> but I'm hoping there's a quicker and easier way to do this than that.
>> Can anyone help out..? I'm sure this isn't too unusual a situation for
>> developers on Windows.
> Simply install manually both versions, giving different names for each
> service, set the service to the "manual" state, so windows will not
> turn it on automatically, then create simple batch files like that:
> net stop mysql4
> net start mysql5
> and another
> net stop mysql5
> net start mysql4
> Place a shortcut on your Desktop and you can quickly switch between
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
> ------END GEEK CODE BLOCK------