How to install two mysql on the same computer
How do I install two mysql on the same computer? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!
The mysql can hold two. Installation steps: 1, normally install the first mysql on disk c, and then close the service; 2, put another MySQL file on disk D; 3, configure the my.ini file on disk D, change all ports to 3307countries 4, create a second mysql service, and modify the registry configuration.
Steps to install two mysql on one computer
Step 1: install the first mysql normally, and then shut down the service in Control Panel-Management tools-Service.
Step 2: copy the MySQL folder under C:\\ Program Files and copy it to disk E.
Step 3: find the my.ini file of the original mysql (some are directly in C:\\ Program Files, some are not, this time I am under C:\\ ProgramData\\ MySQL\\ MySQL Server 5.7)
Step 4: copy the my file of the original mysql found and put it in the new mysql_base folder E:\\ MySQL\\ mysql_base.
Step 5: modify the copied my file, as shown in the figure
This is to change all ports to 3307, and the mysql port on disk C is 3306.
Modify basedir and datadir when I copied the mysql folder here, the data folder was not together, it was at programdata, so I have to go to programdata to copy the data folder.
Step 6 create a service
First, cmd changes to the directory E:\\ MySQL\\ MySQL Server 5.7\\ bin
And then write.
Mysqld install MySQL2-defaults-file= "E:\\ MySQL\\ mysql_base\\ my.ini"
Step 7 modify the registry
Run-regedit to open the registry
HKEY_LOCAL_MACHINE-- > SYSTEM-- > CurrentControlSet-- > Services will find MySQL2.
Modify the content of MySQL2 as shown in the figure
Basically, just modify the previous section of defaults to find the path where mysqld is located and put it on it.
Step 8 Control Panel Control Panel-Management tools-the MySQL before the service is enabled and the MySQL2 just now
That's about it.
Thank you for reading! After reading the above, do you have a general idea of how to install two mysql on the same computer? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.
