How to install MySQL in zip format

There are two types of 1.MySQL installation files, one in MSI format and one in ZIP format. If the MSI format can be directly clicked on the installation, according to the installation prompts it to install (I believe you can read English tips), General MySQL will be installed in C:\Program files\mysql\mysql Server 5.6 Directory The ZIP format is self-extracting, and after decompression, MySQL can actually be used, but to configure.

2. After the decompression can rename the folder, put in the appropriate location, personal suggestions to rename the folder to MySQL Server 5.6, put in the C:\Program files\mysql path. Of course you can also put in any position you want to put;

3. After completing the above steps, many users start using MySQL, but errors occur. This is because environment variables are not configured. Configuring environment variables is simple:

-Environment variables, properties----My Computer
-Select Path, after which add: your path to the MySQL Bin folder (e.g. C:\Program files\mysql\mysql Server 5.6\bin) path= ...; C:\Program files\mysql\mysql Server 5.6\bin (note is append, not overwrite)

4. After configuring the environment variables do not be busy to start MySQL, we also need to modify the configuration file (if not configured, after the start of the error will appear in the diagram Oh!). : Error 2 system cannot find file), mysql-5.6.1x default configuration file is C:\Program files\mysql\mysql Server 5.6\my-default.ini, or create a my.ini file yourself;
Put the configuration file in the
[Mysqld]
Basedir= ...
Datadir= .....
Change into
[Mysqld]
Basedir=c:\program files\mysql\mysql Server 5.6 (MySQL directory)
Datadir=c:\program files\mysql\mysql Server 5.6\data (the directory where MySQL resides \data)

5. Start---command prompt-right----Run as Administrator (A), which opens a command prompt as an administrator

1) Open the DOS window and go to the MySQL bin directory (note: Be sure to open a command prompt as an administrator, as these actions are only available to administrators)
2) Execute mysqld--install Mysql5.6, the execution will prompt service successfully installed

However, if you do not open a command prompt as an administrator, you will be prompted when you execute the above command: Install/remove of the service denied! (Service installation is denied)

3) Then you can see the Mysql5.6 service in the Windows service.

6. The above can start MySQL, later is the additional part

1) mysqld--remove mysql5.6 remove MySQL service from Windows services

2) net start mysql5.6 open MySQL Service

3) net stop mysql5.6 shutdown MySQL Service

4) mysqld--install-manual

How to install MySQL in zip format