MySQL 5.7.18 Compressed Package Edition configuration record

1, extract to a directory (recommended root directory), such as: D:\mysql
2. Add D:\mysql\bin in the system path
3, this version without My-default.ini, need to write, put in D:\mysql\my.ini, relevant parameters can refer to mysqld--verbose--help

[client] Port=3306default-character-set=UTF8[mysqld]Port =3306character_set_server=Utf8basedir=D:\mysqldatadir=D:\mysql\datasql_ Mode=no_engine_substitution,no_auto_create_user

4, installation as a service: Mysqld.exe-install

5, initialize the system database: Mysqld--initialize-insecure, automatically create the data directory after initialization and the root user of the empty password (not recommended--initialize, generate random password, this version is not shown in data\*. Can be found in the Err file)
6. Start MySQL service: net start MySQL
7, initialize the root password: mysqladmin-u root-p password new password, empty password directly enter

MySQL 5.7.18 Compressed Package Edition configuration record