Custom Search
 


How to install two different versions of MySQL server on the same PC



MySQL is the world's most popular open source Relational Database Management System (RDBMS).

A computer can run more than one instance of MySQL server with different versions. This article provides a step-by-step server configuration guide for MySQL 4.1 (release 4.1.18) on Windows as a development box when there is already another instance of different version of MySQL server installed.

What you need

  1. A previous version of MySQL server has already been installed and is running. Here we assume MySQL 4.0.25 was installed already.

  2. You should have installed MySQL 4.1 release 4.1.18 (other releases for version 4.1 should be fine). If not, see How to install MySQL 4.1 on Windows.

  3. Windows 2000 or XP (may work on Windows 9x but never tested).

MySQL Server Configuration Steps

  1. Start MySQL Server Instance Configuration Wizard.

    If you have selected the checkbox 'Configure the MySQL Server now' in the last step when installing MySQL 4.1, the configuration wizard should start automatically when you click [Finish] button. Alternatively, you can launch the wizard from Start menu. Start -> Programs -> MySQL -> MySQL Server 4.1 -> MySQL Server Instance Config Wizard.

  2. Select Detailed Configuration and click [Next].

  3. Select Developer Machine and click [Next].

  4. Select Transactional Database Only (this option optimizes InnoDB tables to enforce data and referential integrity). Click [Next].

  5. InnoDB Tablespace Settings. We are installing on a developer machine. So the default setting can be left as is. Click [Next].

  6. Choose Online Transactional Processing (OLTP) and click [Next].

  7. Select TCP/IP port 3307 because 3306 is the default and has been used by your previous installation of MySQL. This will allow two instances of MySQL server to be accessed via different ports on the same box. If you select 3306, the wizard will prompt that the port 3306 is already in use.

  8. Choose the Standard Character Set (this is the default character set).

  9. Install MySQL server as a Windows service. Select the Service Name MySQL41 from the drop-down box to match with the MySQL version you are installing. By default, the Service Name 'MySQL' has already been used by your previous installation of MySQL. You can also check 'Include Bin Directory in Windows PATH' if you want to operate MySQL from command line.

  10. Set a new password to root account. When MySQL was installed, the password for root account was blank. Now it is time to set a new password to it. Don't select the Create An Anonymous Account checkbox. This can lead to an insecure system.

  11. Now everything is ready to execute. Click [Execute] button to run it.

  12. The configuration file has been created successfully. Click [Finish] to close the wizard.

Errors you may receive

If you re-install MySQL 4.1 and your previous installation directory has not been deleted, you will receive the following error when you have pressed [Execute] button (see screenshot above). In this case, just click Skip and the configuration will continue to execute. When finishes, it will show that the security settings could not be applied (Error Number 1045 - Access denied for user 'root'@'localhost' (using password: NO).

You should click [Cancel] and then re-run the Configuration Wizard from the Start menu.

Start -> Programs -> MySQL -> MySQL Server 4.1 -> MySQL Server Instance Config Wizard.

Now you can install multiple versions of MySQL server on the same computer. For information about how to access them from either SQLyog or PHP, read this article.

Happy installing!


Copyright© GeeksEngine.com



Related Articles:

1.Steps to install PHP 5.x on Windows as a development machine
2.How to install Apache 2.x web server on Windows
3.How to connect two different versions of MySQL server on the same computer
4.How to configure MySQL server 5.1 on Windows
5.How to install MySQL server 5.1 on Windows with screenshots
6.Five ways to create include path for PHP
7.How to use Date and Time data as integer value in PHP and MySQL
8.How to use Apache Virtual Host to run multiple local websites on Windows
9.Install all PEAR packages by yourself
10.How to install PEAR on Windows
11.How to use PHP and Microsoft SMTP Virtual Server to send emails
12.How to install PHP server-side scripting language on Windows
13.How to install Apache 1.3 web server on Windows
14.How to configure MySQL server 4.1 on Windows
15.How to install MySQL server 4.1 on Windows with screenshots
16.Export Northwind Access database to MySQL via ODBC


Other Recent Articles from the WAMP & LAMP category:

1.How to resolve Apache web server port 80 access problem
2.The free tools I use to build PHP and MySQL websites
3.Steps to install PHP 5.x on Windows as a development machine
4.How to install Apache 2.x web server on Windows
5.How to connect two different versions of MySQL server on the same computer
6.How to configure MySQL server 5.1 on Windows
7.How to install MySQL server 5.1 on Windows with screenshots
8.How to upgrade from PHP4 to PHP5
9.How to load time zone data for MySQL on Windows
10.How to use Apache Virtual Host to run multiple local websites on Windows
11.Install all PEAR packages by yourself
12.How to install PEAR on Windows
13.How to use PHP and Microsoft SMTP Virtual Server to send emails
14.How to install PHP server-side scripting language on Windows
15.How to install Apache 1.3 web server on Windows
16.How to configure MySQL server 4.1 on Windows
17.How to install MySQL server 4.1 on Windows with screenshots
18.How to set up DSN in ODBC Data Source Administrator on Windows

Copyright © 2017 GeeksEngine.com. All Rights Reserved.

This website is hosted by HostGator.

No portion may be reproduced without my written permission. Software and hardware names mentioned on this site are registered trademarks of their respective companies. Should any right be infringed, it is totally unintentional. Drop me an email and I will promptly and gladly rectify it.

 
Home | Feedback | Terms of Use | Privacy Policy