MySQL Decompression version installation steps （Windows）

Important things are to be repeated for 3 times ：
notes ： If the system has been installed mysql, If you have configured environment variables , Mind deleting the environment variable first , Otherwise, the login failure may appear in the subsequent login .
notes ： If the system has been installed mysql, If you have configured environment variables , Mind deleting the environment variable first , Otherwise, the login failure may appear in the subsequent login .
notes ： If the system has been installed mysql, If you have configured environment variables , Mind deleting the environment variable first , Otherwise, the login failure may appear in the subsequent login .

1. decompression mysql Installation package , The extracted folder is the installation directory , Such as D:\mysql-8.0.11-winx64
2. Create a new configuration file in the installation directory my.ini, The contents are as follows: ：

[mysql]
#  Set up mysql Client default character set 
default-character-set=utf8 
[mysqld]
# Set up 3306 port , Port number can be customized , Just don't conflict with the previous version 
port = 3306
#  Set up mysql Installation directory 
basedir=D:\MySQL\mysql-5.7.31-winx64
#  Set up mysql Database data storage directory 
datadir=D:\MySQL\mysql-5.7.31-winx64\data
#  Maximum connections allowed 
max_connections=200
#  The character set used by the server defaults to 8 Bit coded latin1 Character set 
character-set-server=utf8
#  The default storage engine that will be used when creating a new table 
default-storage-engine=INNODB
#default-time_zone  Default time zone , You can leave it blank , But for use now() convenient , It is recommended to set 
default-time_zone = '+8:00'
#  Solve the problem of grouping query 
sql_mode ='STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'

3. Create a folder in the installation directory data

4. Running as an administrator cmd Command window ( Note that the command line in administrator mode , Otherwise, the prompt of insufficient permission may appear )

5. In the command window, enter... Under the installation directory bin Catalog , An example command is as follows ：

d:
cd \mysql-8.0.11-winx64\bin

6. Run the following command , This command initializes mysql, And output information on the console , At the same time, a temporary password is generated and displayed on the console , Please remember the temporary password

mysqld --initialize --console

7. Run the following command , install mysql service , The service name is MySQL, The service name can be modified , But it cannot have the same name as other versions ,

mysqld --install MySQL

8. Run the following command to enable mysql service

net start MySQL

9. Run the following command , With root Login to the database with identity and temporary password
   notes ： If two... Are installed mysql Under the circumstances , install mysql8 when ,
   Login should be in : mysql -P3306 -uroot -p Enter and the password will be displayed , Enter the temporary password , To log in

10. Log in mysql Then run the following command , modify root password , Change the password you want to set
    set password=‘xxxxx’;

Finally, log out , Login again and you can use the new password .

appendix

1. stop it mysql service :net stop mysql
2. uninstall mysql service :mysqld remove [mysql service name ] ( Running as an administrator cmd Command window , And enter... Under the installation directory bin Catalog )