Different MySQL versions on the same Windows server

Linux

We can only have one version of MySQL setup on the machine using the default installation procedure with apt-get.

If we try to install one version over another, it will replace the first version and will retain the second version.

Windows

In Windows, we can install different MySQL versions on the same server using the installer:

1. Install the first instance.

   1. Download MySQL Installer for windows and run it.

   2. Check and install requirements for MySQL products, Install MySQL, Configure MySQL Server, Set password for root account, (create another user), Create a service for MySQL Server, Apply configuration (= execution of all the above), Finish.
2. Run MySQL Installer again, Press “Add” button and you will get all MySQL products list.
3. Choose the MySQL version you need and move it to “Products to be installed” list.
4. “Next” and move to other steps that similar to the regular installation: Check and install requirements, Download, Installation.
5. After installation is finished, “Next” to configuration or if there is no “Next”, Select this version in the installation list and press “Reconfigure”.
6. Configure MySQL Server: Set password for root account, (create another user), Create a service for MySQL Server, Apply configuration.
7. Finish.
8. Checks:
   
   1. The "C:\Program Files\MySQL" folder will have two “MySQL Server x.x” folders - one for each version.
   2. The " C:\ProgramData\MySQL " folder will have two data folders - one for each version.
   3. MySQL service should be created for each version.
9. Enable Remote connection.