MySQL installation

One 、 download

1、 Address ：https://dev.mysql.com/downloads/mysql/
2、 The latest is 8.0 edition , I chose the last latest one mysql-5.7.24-winx64.zip

Two 、 install

1、MySQL There are two kinds of installation files .msi and .zip ,.msi Need to install .
2、zip The format is to decompress by yourself , After decompression, actually MySQL You can use it , But you need to configure environment variables zip The format is to decompress by yourself .
3、 My computer -> attribute -> senior -> environment variable
choice Path, Add after : Yours mysql bin Path to folder ：
F:\mysql\mysql-5.7.24-winx64\mysql-5.7.24-winx64\bin;
4、 After configuring environment variables , stay F:\mysql\mysql-5.7.24-winx64\mysql-5.7.24-winx64 Add a new configuration file under the directory mysql.ini , At the same time bin Create a data Folder （ Used to store database data ）
5、mysql.ini The contents of the document are as follows ：

[mysql]

#  Set up mysql Client default character set 
default-character-set=utf8 

[mysqld]

# Set up 3306 port 
port = 3306 

#  Set up mysql Installation directory 
basedir=F:\mysql\mysql-5.7.24-winx64\mysql-5.7.24-winx64

#  Set up mysql Database data storage directory 
datadir=F:\mysql\mysql-5.7.24-winx64\mysql-5.7.24-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

6、 open cmd, You don't need to go to the installation directory （∵ Environment variables have been configured before ）, Enter the following command , enter , No response

mysqld --initialize-insecure --user=mysql

7、 Enter the following command , enter , It will prompt that the installation is successful

mysqld install

8、 Start the service , Enter the following command , enter , After successful startup, it is shown in the figure below

net start mysql

9、 After the service starts successfully , Enter the command when you need to log in （ No password for the first login , Press enter directly to pass ）

mysql -u root -p

10、 Change Password （ Must be started first mysql）, Execute the following command and enter ,enter password Come back , The password is usually set to root, Convenient memory

mysqladmin -u root -p password

11、 sign out exit That's it , Remember to close directly cmd The window doesn't exit , To input exit I'll quit

————————————————

Reference ：

https://blog.csdn.net/weixin_42869365/article/details/83472466