Compressed package installation MySQL Service

The last time I forgot to compress the package how to install the MySQL service, hope not to forget again

There are two ways to install MySQL on Windows, using Mysqlinstaller, using compressed files

Some points to be aware of
1, unzip the directory is the installation directory.
2, build configuration file (Option files), after extracting the root directory has my-default.ini. Official website describes MySQL server in Windows
The configuration file can be named My.ini (preferred), my.conf (), in C \, the installation directory, etc. at startup
If the C drive is not a boot disk, you cannot use my.conf.
3,mysql 5.7.6 after the compressed package no longer contains the data directory, you can use--initialize or--initialize-insecure
Initialization The random password generated by--initialize is saved in the Data\[computer name].err file,--initialize-
The password generated by insecure is empty. Modify password statement alter USER ' root ' @ ' localhost ' identified by
' New_password ';
4, related command: mysqld--remove uninstall MySQL service, mysqld--install install MySQL service. After the service is successfully installed, you can initialize the operation.
Then use the net start mysql,net stop MySQL command to start the stop service.

Compressed package installation MySQL Service