WIN10 installation MySQL-5.7.11

1. Official website Download mysql:http://dev.mysql.com/downloads/mysql/
2. Unzip the downloaded zip package to the directory you want to install
3. Create a new My.ini configuration file in the directory

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
Port = 3306
#Skip-grant-tables (this line for the first login skip the input password, direct enter skip the input password link, time to remove the comment #)
# set up the MySQL installation directory
Basedir=d:\program files\mysql-5.7.11-winx64
# Set up a storage directory for MySQL database data
Datadir=d:\program Files\mysql-5.7.11-winx64\data
# 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

　　

4. Enter CMD as Administrator

• Into the bin of MySQL
• Initialize, Generate Data folder

>mysqld--initialize

• Installing the MySQL Service

>mysqld-install

• Start MySQL

>net start MySQL

• Log in to MySQL

>mysql-u root-p

(Prompt for password, no password directly enter login)

5. Change the root password

mysql> Update Mysql.user Set Authentication_string=password (' YourPassword ') where user= ' root ';

Mysql> quit; (Quit MySQL)

6. Comment out the skip-grant-tables in the My.ini configuration file

7. Restart the MySQL service

• >net stop MySQL
• >net start MySQL

WIN10 installation MySQL-5.7.11