win10， mysql-8.0.26-winx64. Zip installation

1、 download mysql-8.0.26-winx64.zip

Download address ： https://dev.mysql.com/downloads/mysql/,
As shown in the figure below ：

2、mysql-8.0.26-winx64.zip decompression

take mysql-8.0.26-winx64.zip Unzip to D:\dev_tools\mySQL\mysql-8.0.26-winx64 , As shown in the figure below ：

3、 To configure my.ini

my.ini The contents are as follows ：

[mysqld]
#  Set up 3306 port 
port=3306
#  Set up mysql Installation directory 
basedir=D:/dev_tools/mySQL/mysql-8.0.26-winx64
#  Set up mysql Database data storage directory 
datadir=D:/dev_tools/mySQL/mysql-8.0.26-winx64/data
#  Buffer directory 
tmpdir=D:/dev_tools/mySQL/mysql-8.0.26-winx64/tmp

#  Maximum connections allowed 
max_connections=200

#  Number of connection failures allowed . This is to prevent someone from trying to attack the database system from the host 
max_connect_errors=10

#  The character set used by the server defaults to UTF8
character-set-server=utf8mb4

#  The default storage engine that will be used when creating a new table 
default-storage-engine=INNODB

#  By default “mysql_native_password” Plug in authentication 
default_authentication_plugin=mysql_native_password

#  Between high and low versions , Date compatibility optimization 
explicit_defaults_for_timestamp=true

[mysql]
#  Set up mysql Client default character set 
default-character-set=utf8mb4

[client]
#  Set up mysql The default port when the client connects to the server 
port=3306
default-character-set=utf8mb4

take my.ini Save to mysql-8.0.26-winx64 root directory .
establish data 、tmp Catalog .

4、 Configure environment variables

4.1、 establish MYSQL_HOME

MYSQL_HOME = D:\dev_tools\mySQL\mysql-8.0.26-winx64

4.2、 Add to Path environment variable

stay Path In the environment variables add to

%MYSQL_HOME%\bin

, As shown in the figure below ：

5、MySQL initialization

stay cmd Command line , Enter the following command ：

mysqld --initialize --console

If initialization is successful , At the end of the last line is the password , Remember that .

6、 install 、 start-up MySQL

6.1、 install MySQL service

install MySQL service , stay cmd Command line , Enter the following command ：

mysqld --install mysql80

Service successfully installed. Indicates successful installation .

6.2、 start-up MySQL service

stay cmd Command line , Enter the following command ：

net start mysql80

The prompt message indicates MySQL Successful launch .

7、 Get into MySQL Command mode of

stay cmd Command line , Enter the following command ：

mysql -u root -p

next , Input password （MySQL On initialization , The default password given ）,

You can get into MySQL Command mode of .

8、 Change Password

stay MySQL In command mode , You can change the password .

take root Password set to 123456, As shown in the figure below ：

ALTER user 'root'@'localhost' IDENTIFIED BY '123456';