Install Multiple mysql databases under win7
(1) install mysql in the corresponding directory. The default port for installing mysql is 3306.
(2) Copy all MYSQL_PATH files to the mysql directory you want to install, tentatively set to MYSQL3307,
(3) modify the mysql configuration file my. ini under MYSQL3307 and modify the corresponding parameters.
(4) Installation Service
Enter the following content in the cmd command (if you have permissions in win7, find cmd.exe as an administrator. Otherwise, an error will occur)
Cd MYSQL3307 \ bin
Mysqld -- install mysql3307 (you can also use another name)
(5) modify the executable path of the newly added Service
Run regedit to open the windows Registry Editor and find
HKEY_LOCAL_MACHINE \ SYSTEM \ CURRENTCONTROLSET \ SERVICES \ corresponding service
Change the corresponding ImagePath to "MYSQL3307 \ bin \ mysqld" -- defaults-file = "MYSQL3307 \ my. ini" MySQL3307
(6) start mysql3307 run cmd input net start mysql3307