Install MySQL 5 instances manually in Windows

1. Download the free installation package from the official MySQL websiteProgram.


2. decompress the package and copy the directory to the actual running directory. For example, D: \ Program Files \ mysql \ mysql3307.

3. Copy the my-large.ini to the same directory
My. ini.

4. Open My. ini
File Modification port (required) and other configurations (not required ).

5. Registration Service: D: \ Program
Files \ mysql \ mysql3307 \ bin \ mysqld.exe -- install mysql53307. (Mysql53307 indicates the service name)


6. Open the registry and locate
[HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ mysql53307] node, modify
ImagePath value: "D: \ Program Files \ mysql \ mysql3307 \ bin \ mysqld-nt"
-- Defaults-file = "D: \ Program Files \ mysql \ mysql3307 \ My. ini"
Mysql53307. (This can also be defined directly when registering a service, but I did not try it .)

7. Start the service: Net start
Mysql53307.

8. Use the command line to enter the database instance: D: \ Program
Files \ mysql \ mysql3307 \ bin \ mysql.exe-u root.

9. Change the password: Set password
Root @ localhost = PASSWORD ('newpwd ');.

10. Restart the service :.