Re: jayme : Running different versions of MySQL

It's possible, I've been running version 3.23, 4.0.21 and 4.1.7 at the
same time, using (of course) different ports for tcp/ip communication,
for testing purposes, since my system is WinXP Pro, I guess you can do
the same at win2000 Pro.

When you install MySQL 4.1.7, you can use the MySQL Tray Monitor to
configure different instances, with different configs at the same time
(just be sure to avoid compatibility problems with variables and
options for each version).

Good luck,

On Thu, 25 Nov 2004 18:14:25 -0200, Jayme Jeffman Filho
wrote:
> I would like to know if it is possible to install "mysql-3.23.52-win" and
> "MySQL4.1.7" on the same computer on Windows 2000 Professional. They won't
> run at the same time. My ISP has a 3.23.xx version and I need to try the PHP
> pages before uploading them, but I'd like to use the latest version on my
> PC.
>
> TIA.
>
> Jayme.
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

jayme : Running different versions of MySQL

I would like to know if it is possible to install "mysql-3.23.52-win" and
"MySQL4.1.7" on the same computer on Windows 2000 Professional. They won't
run at the same time. My ISP has a 3.23.xx version and I need to try the PHP
pages before uploading them, but I'd like to use the latest version on my
PC.

TIA.

Jayme.



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: jayme : Running different versions of MySQL

You've actually got a *lot* of choices if you want to run multiple
MySQL versions locally:

different ports
different IP addresses
multiple services, but only one active

The simplest is to only activate one at a time -- stop the 3.23
service and start the 4.0 service for example, but that won't let you
test both simultaneously for things like replication or to run two
copies of a web app to test, etc.

Different ports is the next easiest, though it requires adding a new
default port everywhere you defined connection information --
hopefully that's all in a JDBC setting, global variable, etc. You'll
also need to remember to pass the port in all the command line mysql
commands and in any GUI tools.

The third option is to assigning additional IP addresses to one of
your network adaptors -- you can use "fake" ip addresses like
127.0.1.X or additional IPs off your 192.168.X.X address if you're on
a NATted router -- then you can bind MySQL instances to specfic
addresses

The third options a bit more work, but I find it a lot easier in the
long run since everything runs on the standard port -- you can even
modify your hosts file to have mysql323.mybox.com and mysql4.mybox.com
point at your local IP addresses. IMHO, it's always easier to build a
test environment that is right for your application rather than modify
your application (e.g. change all the port information) so that it
matches your test environment.


On Thu, 25 Nov 2004 17:35:17 -0200, Daniel da Veiga
wrote:
> It's possible, I've been running version 3.23, 4.0.21 and 4.1.7 at the
> same time, using (of course) different ports for tcp/ip communication,
> for testing purposes, since my system is WinXP Pro, I guess you can do
> the same at win2000 Pro.
>
> When you install MySQL 4.1.7, you can use the MySQL Tray Monitor to
> configure different instances, with different configs at the same time
> (just be sure to avoid compatibility problems with variables and
> options for each version).
>
> Good luck,
>
> On Thu, 25 Nov 2004 18:14:25 -0200, Jayme Jeffman Filho
>
>
> wrote:
> > I would like to know if it is possible to install "mysql-3.23.52-win" and
> > "MySQL4.1.7" on the same computer on Windows 2000 Professional. They won't
> > run at the same time. My ISP has a 3.23.xx version and I need to try the PHP
> > pages before uploading them, but I'd like to use the latest version on my
> > PC.
> >
> > TIA.
> >
> > Jayme.
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
> >
> >
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=john.paul.ashenfelter@gma il.com
>
>


--
John Paul Ashenfelter
CTO/Transitionpoint

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: jayme : Running different versions of MySQL

Jayme Jeffman Filho wrote on Monday, November
29, 2004 2:13 PM:

> Now I have two instances of MySQL running on the same computer,
> but I still can't connect to MySQL 4.1.7 using PHP 4.3.9. The mysqli
> functions are not present. Should I use a PHP 5.x version ?

Does phpinfo() show MySQLi extensions available? You may need to add the
extension=php_mysqli.so (or extension=php_mysqli.dll for Windows)
line to php.ini.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: jayme : Running different versions of MySQL

Now I have two instances of MySQL running on the same computer,
but I still can't connect to MySQL 4.1.7 using PHP 4.3.9. The mysqli
functions are not present. Should I use a PHP 5.x version ?

TIA.

Jayme.

----- Original Message -----
From: "Jayme Jeffman Filho"
To:
Sent: Thursday, November 25, 2004 6:14 PM
Subject: jayme : Running different versions of MySQL


> I would like to know if it is possible to install "mysql-3.23.52-win" and
> "MySQL4.1.7" on the same computer on Windows 2000 Professional. They
won't
> run at the same time. My ISP has a 3.23.xx version and I need to try the
PHP
> pages before uploading them, but I'd like to use the latest version on my
> PC.
>
> TIA.
>
> Jayme.
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: jayme : Running different versions of MySQL

------=_NextPart_000_1C19_01C4D619.728F0AC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

The php_mysqli.dll was not shipped with the binary
installer.
The mysqli functions are not defined !

TIA

Jayme.

----- Original Message -----
From: Tom Molesworth
To: 'Jayme Jeffman Filho' , win32@lists.mysql.com
Sent: 29-Nov-2004 11:46:14 -0200
Subject: RE: jayme : Running different versions of MySQL
Jayme Jeffman Filho wrote on Monday, November
29, 2004 2:13 PM:

> Now I have two instances of MySQL running on the same computer,
> but I still can't connect to MySQL 4.1.7 using PHP 4.3.9. The mysqli
> functions are not present. Should I use a PHP 5.x version ?

Does phpinfo() show MySQLi extensions available? You may need to add the
extension=php_mysqli.so (or extension=php_mysqli.dll for Windows)
line to php.ini.




------=_NextPart_000_1C19_01C4D619.728F0AC0--

Re: jayme : Running different versions of MySQL

>

> ------------------------------
>
> Date: Mon, 29 Nov 2004 12:13:21 -0200 To:
> From: "Jayme Jeffman Filho" Subject: Re: jayme :
> Running different versions of MySQL Message-ID:
> <000101c4d617$344893a0$13471e0a@gseew2k>
>
> Now I have two instances of MySQL running on the same computer, but
> I still can't connect to MySQL 4.1.7 using PHP 4.3.9. The mysqli
> functions are not present. Should I use a PHP 5.x version ?
>
> TIA.
>
> Jayme.
>

mysqli is available only in PHP 5 (it would be nice if the PHP Manual
made this plain).

You can connect to MySQL 4.1+ using the mysql extension (in either PHP 4
or PHP 5), but if you do this, you'll also need to do one of:

(a) set passwords for users of the 4.1.7 server using the OLD_PASSWORD()
function

or

(b) configure the 4.1.7 server with old-passwords in the my.cnf (or
possibly my.ini on win32) file

See http://dev.mysql.com/doc/mysql/en/Password_hashing.html and
http://dev.mysql.com/doc/mysql/en/Application_password_use.h tml for more
info.

Note that ext/mysql only knows the old password hashing (as used before
MySQL 4.1), whereas ext/mysqli can use the old and new methods for
password hashing, and will "know" automatically which is being used by
the server it's trying to connect to.

--
Jon Stephens, Technical Writer
MySQL AB www.mysql.com
Office: +61 (7) 3388 2228
Are you MySQL certified? www.mysql.com/certification

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org