Procedures for installing and uninstalling MySQL under Windows (zip format)

MySQL is a small but powerful database, which is very popular at present. The installation package is available in two formats, one in MSI format and one in ZIP format. The following is the ZIP format installation, uninstallation and precautions.

1. Installation:

Unzip the downloaded MySQL into the specified directory (e.g. d:\mysql)

To install the service, open a command Prompt window: Run--->cmd

At the command line, enter: D:\mysql\bin\mysqld-install
Start service: net start MySQL

After installing MySQL as a service, you will see the MySQL service in the Service.msc service

After completing the above steps, configure the environment variables for MySQL. Configuring environment variables is simple:

My Computer (computer), properties--Advanced environment variables

Select Path, after which you add: the path to the MySQL Bin folder, such as: D:\mysql\bin (note is appended)

After configuring the environment variable also need to modify the configuration file (if not configured, then the error may occur after startup), the default configuration file path is the MySQL directory My-default.ini, or create a My.ini file yourself, as follows is a simple example, for reference only:

[Mysqld]

Default-character-set = UTF8

Basedir = D:\mysql

DataDir = D:\mysql\data

[Client]default-character-set = UTF8

[Winmysqladmin] Server = D:\mysql\bin\mysqld.exe

Now that the installation is complete, start the service

2. Uninstall:

Uninstalling the service is simple
Stop the service first, enter: net stop MySQL at the command line
Delete Service: D:\mysql\bin\mysqld-remove

This article is from the "ISKORPITX" blog, make sure to keep this source http://chinaxin.blog.51cto.com/1109725/1873234

Procedures for installing and uninstalling MySQL under Windows (zip format)