MySQL Decompression version Installation instructions

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 (folder MySQL below is 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\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 The default configuration file is in Mysql\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),
Entry: C:\Program Files\mysql\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

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,
If it is the first time to install into six, otherwise go in seven

Six

Connect to the database (do not enter with MySQL)
MySQL bin directory, C:\Program files\mysql\bin>mysql-u root mysql---First installation use this to enter the database

Set Password

mysql> Update user Set Password=password (' test_123 ') where user= ' root ';
Query OK, 2 rows affected (0.02 sec)
Rows Matched:3 Changed:2 warnings:0

mysql> FLUSH privileges;
Mysql> quit

Then you can connect to MySQL as usual.

Seven normal connection SQL methods

Enter Mysql-u root-p, then enter the password

MySQL Decompression version Installation instructions