MySQL 5.7.23 decompression version installation tutorial with pictures and text

It is too troublesome to find the installation tutorial every time, so I back up the steps for myself to check later. Unzip version download address

https://dev.mysql.com/downloads/mysql/, the detailed diagram is as follows:

1. Choose the one that suits you to download according to your needs.

2. Unzip the installation package to your favorite path. I chose D:\Program Files\

3. Configure environment variables

I am using Windows 10, find the environment variable configuration location

Add environment system variables

MYSQL_HOME

D:\Program Files\mysql-5.7.23-winx64

Edit the path variable and add MYSQL_HOME

4. Create a new my.ini file. There is no such file in version 5.7, so you need to create it yourself. The content is as follows. Please note that you need to modify your own file address.

[mysqld]
port = 3306
basedir=D:/Program Files/mysql-5.7.23-winx64
datadir=D:/Program Files/mysql-5.7.23-winx64/data 
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
default-character-set=utf8

Put the my.ini file in the D:\Program Files\mysql-5.7.23-winx64 directory.

5. Open the cmd command window and switch to the MySQL directory.

6. Execute the mysqld -install command to install

7. Execute mysqld --initialize-insecure --user=mysql command to initialize

After success, the data directory will be generated and the root user will be created.

8. Execute the net start mysql command to start MySQL.

9. If the startup is successful, execute the "mysqladmin -u root -p password new password" command to set the password. The old root password is empty, just press Enter.

The decompressed version installation is now complete.

Summarize

The above is the detailed graphic installation tutorial of MySQL5.7.23 decompressed version introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!
If you find this article helpful, please feel free to reprint it and please indicate the source. Thank you!