Installing MySQL 8.0.12 based on Windows

[mysql]
; Set the mysql client default character set default-character-set=utf8
[mysqld]
; Set port 3306 port = 3306
; Set the installation directory of mysql basedir=D:\Software\Programming Software\Database\MySQL\mysql-8.0.12-winx64
; Set the storage directory of mysql database data datadir=D:\Software\Programming Software\Database\MySQL\mysql-8.0.12-winx64\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

#Enter the MySQL installation directory:
cd /d D:\mysql-8.0.12-winx64\bin
(Do not copy and paste directly here, because the folders we create may not be the same, so be sure to check your own installation directory)

#Execute the command to install MySQL:
mysqld install

#Execute the following command to initialize the data directory (after 5.7, you must execute this command before you can start mysql)
mysqld --initialize-insecure

#Execute the following command to start mysql
net start mysql 

#Execute the following command to log in to mysql. You do not need to enter a password for the first login. Just press Enter. mysql -u root -p 

#After successful login, execute the following command to change the password (change newpassword to the password you set):
alter user 'root'@'localhost' identified with mysql_native_password by 'newpassword';
#After changing the password, execute the following command to refresh the privileges: