"Octavian Rasnita" <[EMAIL PROTECTED]> wrote on 12/02/2005 10:39:16 AM:
> From: "Stephen Cook" <[EMAIL PROTECTED]> > Subject: Re: Cannot start MySQL under Win2000 > > > > You must not install 5.0 over 4.1, put it somewhere else. > > > > Also, instead of naming the service "MySQL" both times, call it > > something else (i.e. "MySQL41" and "MySQL50"). If you use the Windows > > installer distribution, it is one of the options; if you are doing it by > > hand then you already know how to name the services whatever you like. > > > > HTH. > > I have installed MySQL 4.1 in e:\mysql and MySQL 5.0 in e:\mysql5. > MySQL 4.1 service name is mysql and MySQL 5.0 service name is mysql5, so > they are 2 totally separate programs. > > However, I want them both use the same port, because I will run only one of > them in a certain moment, and not both, so there should be no conflict. > > I want this because I want to test the speed difference between MySQL 4 and > MySQL 5 and I don't want to make any change in the program, but change only > the service that listen to MySQL port... > > However, I've just read that the port should be different, even though I > don't know why, and maybe this is the reason I cannot start MySQL 4 even if > MySQL 5 is stopped. > > Thank you. > > Teddy > They only need to use different ports if they are both running at the same time. The documentation describes how to set up multiple, simultaneously operating MySQL servers. As you describe it, you should be able to get them both running (one at a time) on the default port of 3306. The moment you try to allow both of them to bind to that socket at the same time, one of them will puke (usually the one you are just starting) so make sure that one is completely down before you start the other. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
