MySQL 8.0.23 installation and configuration method graphic tutorial under win10

[mysqld]
# Set port 3306 port=3306
# Set the installation directory of mysql basedir=D:\WinInstall\mysql-8.0.23-winx64
# Set the storage directory of mysql database data datadir=D:\WinInstall\mysql-8.0.23-winx64\Data
# Maximum number of connections allowed max_connections=200
# The number of connection failures allowed. This is to prevent someone from trying to attack the database system from this host max_connect_errors = 10
# The default character set used by the server is UTF8
character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
# By default, the "mysql_native_password" plug-in is used for authentication. default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
[client]
# Set the default port used by the mysql client to connect to the server port = 3306
default-character-set=utf8

%MYSQL_HOME%\bin

mysqld --initialize --console #Use this one -- mysqld --initialize --initialize-insecure --user=mysql --console

mysqld --install

net start mysql

mysql -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new password';

exit
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;
use mysql;
update user set host='%' where user = 'root';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password' PASSWORD EXPIRE NEVER;

use mysql;
update user set host='%' where user = 'root';

FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; 
FLUSH PRIVILEGES;