mysql-5.7.12-winx64 download installation and configuration under Windows environment

System: 64-bit Win-7

Official website Compress package: mysql-5.7.12-winx64.zip

Spent some time before and after the download software is installed directly on the local, now this is different, download the compressed package to extract to the installation directory, and then configure the service under the console.

The overall process is as follows:

1. Download:

To http://dev.mysql.com/downloads/mysql/download, or log on to the MySQL website by downloads--community--mysql Community Server sequential access, you can see

My machine is 64-bit, so I chose the second one (344.2M).

The download may require a registered Oracle account, which should be noted with a combination of letters and numbers, with uppercase letters.

2. Unzip:
Unzip the downloaded installation package to the installation directory. My installation directory is D:\Program files\mysql-5.7.12-winx64. After extracting it, go to the parent directory of the bin.

This is the directory where: D:\Program files\mysql-5.7.12-winx64\mysql-5.7.12-winx64

Note that the folder data in is later created, and is not extracted. unzip the new data directory in the same directory as the bin!

3. Configuration:
In the bin directory you can see the My-default.ini file, open, after the original content [Mysqld], add the following content:

Basedir=d:\program files\mysql-5.7.12-winx64\mysql-5.7.12-winx64

Datadir=d:\program Files\mysql-5.7.12-winx64\mysql-5.7.12-winx64\data

port=3306

#这一句解决有IPV6协议的计算机上默认采用IPV6协议导致无法从程序连接数据库的问题

bind-address=127.0.0.1

# Maximum number of connections allowed

Max_connections = 200

# The character set used by the service side defaults to the 8-bit encoded latin1 character set

Character-set-server = UTF8

# The default storage engine that will be used when creating a new table

Default-storage-engine = INNODB

[Client]

# Set the MySQL client default character set

Default-character-set = UTF8

After adding the note: Basedir is the installation path, DataDir is the path of the new data folder after decompression.

4. Installing the MySQL Service

4.1 Start-up in the search bar in the face of the input cmd, do not rush to press ENTER, to right-click the cmd, run cmdas an administrator.

4.2 After running the console, switch the current directory to the next level of the bin directory, mine is D:\Program Files\mysql-5.7.12-winx64\mysql-5.7.12-winx64\bin

4.3 Enter mysqld--initialize-insecure--user=mysql on the 4.2 basis, return.

Use-initialize to generate a random password, as you learn, use-initialize-insecure to generate a blank password. The default account root, the-user=mysql of the following does not change. The password is empty at this time.

4.4 Re-enter mysqld install, enter

Do not worry, my is because has been successful before, will be such a picture.

4.5 Re-enter net start MySQL, enter

4.6 Re-enter Mysql-uroot-p, return, then enter.

Since 4.3 set no password, so the second not to lose the password, direct carriage.

5. Configure the Environment:

This is for later can direct CMD, enter, directly open MySQL.

5.1 Control Panel, System and security--advanced system settings, environment variable->path-> edit to place the full path of the next level directory under MySQL to the front.

5.2 Start-up in the search field of the polygon enter cmd-> enter, directly in the current directory input mysql-uroot-p:

At this point, the software service configuration is complete.

Reference:

Http://jingyan.baidu.com/article/0f5fb0991636376d8234ea7a.html

Http://jingyan.baidu.com/article/597035521d5de28fc00740e6.html

mysql-5.7.12-winx64 download installation and configuration under Windows environment