Windows64 bit installation mysql-5.7.12, graphic

Linux installation MySQL tutorial a large, I will not say, and then how to install this 5.7 version of Windows, and some pits have stepped on!

One: Enter mysql:http://www.mysql.com/downloads/, click community

Two: Select the next version of Windows

Three: Choose Installer

Four: To this interface, there is a direct installation of the package, 32 students see here download finished directly installed can, the back of the Don't look

Five: We want to install the 64-bit server side, select MySQL server

Six: After clicking, select 64-bit free install version

Seven: Click Download, when the jump page to login or register, here is just download, so I chose no

Eight: Download the installation package, wait for the process, OK, after a short wait, download complete, unzip first, simple, extract to D-disk, D:\mysql-5.7.12-winx64

Environment variables can be set here (this will not be checked online), put D:\mysql-5.7.12-winx64\bin in Path

Nine: With some online tutorials, new files in D:\mysql-5.7.12-winx64: My.ini, Content:

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
Port = 3306
# set up the MySQL installation directory can be modified here
Basedir=d:\mysql-5.7.12-winx64
# Set up a storage directory for MySQL database data, which can be modified here
Datadir=d:\mysql-5.7.12-winx64\mydata
# 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

Ten: The key step, this step is a big pit, need to initialize first!!! Press the Win key, enter CMD, open the DOS command window, enter: Mysqld--initialize, return

11: Wait for initialization to complete, input mysqld install MySQL--defaults-file= "D:\mysql-5.7.12-winx64\my.ini", enter

12: Install complete, enter command net start MySQL, finish the work.

Windows64 bit installation mysql-5.7.12, graphic