Can you install two different versions of a MySql database on the same computer?

Question

Can you install two different versions of a MySql database on the same computer?

Navigation

#1 by (0 votes)

0

Is it possible to install a MySql database version (5.7.20.0) on a PC that has already installed a wampserver server that comes by default with a Mysql database version (5.7.19)? I mean, can you install two different versions of a MySql database on the same computer? .

mysql javascript html php css

asked by Luis Requena 17.02.2018 в 01:26

source

1 answer

Error in Yii2 Model Generator: Table does not exist How to make a button repeat its action?

score 0 · Answer 1

Yes, you just have to take into account four important factors one is the name of the service, second the path of installation of files and libraries, third environment variables and the last port number where MySQL listens.

It is easier to manage a program that runs in background in Windows if it is listed as a service, when installing the service you must put a unique name to the service of each installation.

The installation path of files and libraries, in general I mean the installation of the server and the files where the databases are stored, you would have to search that they are not the same, generally MySQL is installed until including the version in the installation folder in your case if you would need to change the name.

In the environment variables in the PATH value, the MySQL folder is usually added at the time of installation, so when you open a console and type the command "mysql -u root" try to open the connection, so you must to be careful what commands you are referring to when executing them if they are from one installation or the other.

The port where you usually hear MySQL is the 3306 but if you want to run both databases at the same time you would have to assign a different port to each installation in the my.cnf file.

I think that generally those four points are the most important to consider, it would not be very advisable to have the two databases running because you would spend a lot of resources on your computer, I would recommend having only one on. In my computer in fact, I have two different versions of MySQL, a 32-bit 5.0 and a 5.7-bit 64-bit version, each of these four points could be much more extensive, I would recommend if you want to deepen them in other questions and on the doubt in specific.