Shulou(Shulou.com)06/02 Report--

This article introduces the knowledge of "how to install multiple windows services under one mysql service". Many people will encounter this dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Make a copy from the installed mysql directory and put it on the side, as shown in the following figure

MySQL Server 5.0is a service that I installed, and I copied it myself.

Modify the my.ini file in the 5.0.1 directory:

Mainly to modify the port, root directory address, data directory address.

Then go to the 5.0.1\ bin directory, type: mysqld-nt install mysqlsalve;, and then prompt you to create the service successfully. When done, go to the registry to change the file and modify the executable path of the service.

Run regedit to open the windows registry editor and find the following items

HKEY_LOCAL_MACHINE\ SYSTEM\ CURRENTCONTROLSET\ SERVICES\ corresponding service

Modify the corresponding ImagePath to "C:\ Program Files (x86)\ MySQL\ MySQL Server 5.0.1\ bin\ mysqld"-- defaults-file= "C:\ Program Files (x86)\ MySQL\ MySQL Server 5.0.1\ my.ini" mysqlsalve

The password of mysql-uroot-hlocalhost-p is the same as that of the mysql you installed. All right, it's done.

The previous one was 5.0. it was too long, so I planned to reinstall it, so I went to mysqll to download it and reinstalled it. It turned out to be disgusting. All I can say is ~

It does not support the parameter-default-file, so delete it, and then data is automatically generated, using the

Mysqld-- initialize-insecure (do not set the root password, recommended)

Then on the line, the install command

Net start mysql

Mysql-hlocalhost-uroot-p

The root account does not have a password.

This is the end of the content of "how to install multiple windows services under one mysql service". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.