Installation method for Windows installation MySQL method mysql5.7

MySQL Installation steps:

1.www.mysql.com download MySQL

2. Unzip the MySQL to E-drive, or other disk after decompression E:\mysql\bin (bin must follow this directory)

3. Create a TXT folder in this bin directory and put

[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
Port = 3306
# set up the MySQL installation directory
Basedir=e:\mysql
# Set up a storage directory for MySQL database data
Datadir=e:\mysql\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
#log-error=e:\mysql\mysql_log_err.txt
#log =e:\mysql\mysql_log.txt
#log-bin=e:/log/mysql/mysql_log_bin
#log-slow-queries= E:\mysql\mysql_log_slow.txt

Save and change the name to: my file extension to: INI is: My.ini

4. Command line: Run command prompt with administrator
CD to E:\mysql\bin folder, execute:
Mysqld Install
After execution succeeds, the initialization command is executed
Mysqld Initialize

5.mysql5.7 after the direct operation is required password;
To use the My.ini file you just configured, execute the statement:
Mysqld--defaults-file= "E:\mysql\my.ini"--console--skip-grant-tables
Once executed, you can use
Mysql-u Root into MySQL
Appear
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 3
Server version:5.7.18 MySQL Community Server (GPL)

Copyright (c), Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Mysql>
is the success.

Installation method for Windows installation MySQL method mysql5.7