It is easy to install multiple Mysql_MySQL instances on Windows.

It is easy to install multiple Mysql bitsCN.com on Windows

Q: How do I install multiple Mysql instances on Windows? A: The specific method is as follows: 1. install Mysql for Windows normally, for example, in the d: mysql folder; 2. configure Mysql as usual; 3. copy the folder installed in the backup, for example, back up the file to another folder, or name it "duplicate mysql"; 4. run the uninstall program to delete the installed MYSQL and folders. 5. restore the backup mysql folder to its original name or to its original location. 6. run the installer again and install it in another directory, for example, "d: mysql2 ". The configuration port is 3307. now, mysql2, the second Mysql installed later, must be able to run normally. let's make the first Mysql service installed at first run normally: in cmd command line mode, enter the in folder of the first Mysql. Run the mysql-nt install mysql2 command. The function is to install a service for Mysql. the service name is mysql2. you can change the service name by yourself, for example, mysql5. the command is:
Mysql-nt install mysql5
After that, run REGEDIT in the running state, open the WINDOWS registry editor, and find the service you just installed in the HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServices project. here is mysql2. Open and modify the following ImagePath value. Generally, you will see a value similar to "D: mysqlinmysqld-nt" mysql2. Add the path information of my. ini between mysql-nt and mysql2. format:

-- Defaults-file = "d: mysqlmy. ini" where the bold part replaces your correct path. after modification, the data value is generally similar to this:

"D: mysqlinmysqld-nt"

-- Defaults-file = "d: mysqlmy. ini" mysql2
Click OK to exit the registry editor.

Then you can start the mysql2 service normally. in the CMD window, enter the following command:

Net start mysql2

Generally, it should be able to start normally. If you encounter a 1067 error, delete the LOG file in your mysqlDATA file and try again. If the error 1067 still persists, check whether the path in -- defaults-file = "d: mysqlmy. ini" is incorrect. if the error 1067 still persists ...... Check your RP

BitsCN.com