Shulou(Shulou.com)05/31 Report--

How to install multiple Mysql in Windows, I believe many inexperienced people are helpless about this, for this reason this article summarizes the causes and solutions of the problem, through this article I hope you can solve this problem.

Q: How do I install multiple Mysql on Windows? Answer: The specific methods are as follows: 1. Install Windows version of Mysql normally, for example, in the d: folder; 2. Configure Mysql according to the general; 3. Copy the backup installed folder, such as backing up to another folder, or named "Copy mysql"; 4. Run the uninstall program to delete the installed MYSQL and folder; 5. Restore the backup mysql folder to its original name or location; 6. Run the installer again and install it in another directory, for example: "d: mysql2"。Configuration port is 3307; now, the second Mysql installed later--mysql2 must be able to run normally, the following to make the first Mysql service installed normally: In cmd command line mode, enter the first Mysql in folder. Execute mysql-nt install mysql2 command. The function is to install a service for Mysql, the service name is mysql2, you can also change the name yourself, such as mysql5, then the command is:

mysql-nt install mysql5

After finishing, run REGEDIT in the runtime, open the WINDOWS Registry Editor, and find the service you just manually installed in the HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServices project, which is mysql2 here. Open and modify the ImagePath values below. You'll typically see something like "D:mysqlinmysqld-nt" mysql2. Add path information for my.ini between mysql-nt"and mysql2 in the format:

--defaults-file="d: mysqlmy.ini" where the bold part replaces your correct path, and the modified data value generally looks like this:

"D:mysqlinmysqld-nt"

--defaults-file="d:mysqlmy.ini" mysql2

OK, exit Registry Editor.

Then you can start mysql2 service normally. Enter the command under CMD window:

net start mysql2

It should normally start. If you encounter error 1067, delete the LOG file in your mysqlDATA file and try again. If it still prompts 1067 error, please check whether the path in--defaults-file="d: mysqlmy.ini" is written incorrectly; if it still prompts 1067 error... please check your RP

After reading the above, do you know how to install multiple Mysql in Windows? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.