Install MySQL (Zip format installation package)

One

Zip format, after decompression to be configured.
After unpacking, you can rename the folder and put it in the appropriate location.
For example, rename the folder to MySQL Server 5.6 (folder MySQL server 5.6 Below is the bin, Data,my-default.ini, etc.)

Two

My Computer, properties, advanced environment variables
Select Path, after which you add the paths to your MySQL bin folder, for example:
C:\Program files\mysql\ MySQL Server 5.6\bin

Three

After configuring the environment variables, don't be too busy starting MySQL, you need to modify the configuration file
If not configured, the error occurs when booting: Error 2 The system cannot find the file
Mysql-5.6.1x default configuration file is in MySQL Server 5.6\my-default.ini,
In which the configuration is modified or added:
[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)

Four

Run cmd as administrator (be sure to run as administrator, or not have enough permissions),
Input: cd c:.......\mysql Server 5.6\bin
Go to the MySQL Bin folder
(regardless of whether the environment variable has been configured, but also to enter the Bin folder, or after the service will still report error 2)
Input Mysqld-install
(If you do not run as an administrator, there will be an error due to insufficient permissions: Install/remove of the Service denied!)

Five

After the installation is successful, start the service and continue typing in cmd:
net start MySQL, the service started successfully!
After the service starts successfully, you can log in,
Enter Mysql-u root-p (first login without password, press ENTER directly)

Six

Service can not find the MySQL service, 5.1 and subsequent version resolved:
D:\mysql\bin>mysqld.exe-install
Service successfully installed.
D:\mysql\bin>net Start MySQL

Seven

The local computer cannot start the MySQL service, error 1067: The process aborted unexpectedly.
Workaround: Modify the configuration file:
[Mysqld]
# set Basedir to installation path, e.g., c:/mysql
# Set the installation directory to MySQL
Basedir=d:/www/webserver/mysql
# set DataDir to location of data directory,
# e.g, c:/mysql/data or d:/mydata/data
# Data Directory set to MySQL
Datadir=d:/www/webserver/mysql/data

Eight

In addition, you have an idea
[Winmysqladmin]
Server=d:/www/webserver/mysql/bin/mysqld-nt.exe
User=root
Password=xxxxxxxx
#以上是设置WinMySQLadmin的配置
[Client]
User=root
Password=xxxxxxxx

Install MySQL (Zip format installation package)