Window environment configuration Mysql 5.7.21 windowx64.zip free installation version tutorial detailed explanation

[mysql]  
# Set the default character set of the mysql client to default-character-set=utf8  
[mysqld]  
#Set port 3306 port = 3306  
# Set the installation directory of mysql to basedir=E:\mysql
# Set the storage directory of mysql database data datadir=E:\mysql\data
# Maximum number of connections allowed max_connections=200  
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8  
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB  
"#" is a comment

E:\mysql\bin>mysqld -install;
Service successfully installed.

E:\mysql\bin>cd ../
E:\mysql> mysqld --initialize-insecure --user=mysql;

E:\mysql\bin> net start mysql;

E:\mysql\bin>mysql -u root -p;
Enter password: //Press Enter here Welcome to the MySQL monitor. Commands end with ; or \g. 
Your MySQL connection id is 2 
Server version: 5.7.21 MySQL Community Server (GPL) 
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. 
Oracle is a registered trademark of Oracle Corporation and/or its 
affiliates. Other names may be trademarks of their respective 
owners. 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 
mysql>

mysql> show databases; 
+--------------------+ 
| Database | 
+--------------------+ 
| information_schema | 
|mysql | 
| performance_schema | 
|sys| 
+--------------------+ 
4 rows in set (0.00 sec)
mysql> use mysql; 
Database changed 
mysql> set password for 'root'@'localhost'=password('new password');
mysql> flush privileges;

mysql> quit;
E:\mysql\bin>mysql -u root -p;
Enter password: